Answer Posted / anil kumar prajapati

olumn "Tablespace" format a13
column "Used MB" format 99,999,999
column "Free MB" format 99,999,999
column "Total MB" format 99,999,999
select
fs.tablespace_name "Tablespace",
(df.totalspace - fs.freespace) "Used MB",
fs.freespace "Free MB",
df.totalspace "Total MB",
round(100 * (fs.freespace / df.totalspace)) "Pct. Free"
from
(select
tablespace_name,
round(sum(bytes) / 1048576) TotalSpace
from
dba_data_files
group by
tablespace_name
) df,
(select
tablespace_name,
round(sum(bytes) / 1048576) FreeSpace
from
dba_free_space
group by
tablespace_name
) fs
where
df.tablespace_name = fs.tablespace_name;

what is grd?

1152

---

What are the different types of database compression introduced in sql server 2008? : sql server DBA

1160

---

how can a session indicate its interest in receiving alerts?

1091

---

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

2389

---

What happens on checkpoint? : sql server DBA

1138

---

how can you get actual data change values from previous transactions in oracle?

1137

---

Which autogrowth database setting is good? : sql server DBA

1237

---

how can you find out if a table can be redefined?

1057

---

what do you understand by flashback feature of oracle?

1042

---

what is the role of dip user in our database?

2461

---

Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit

2343

---

i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?

2123

---

internal architecture

2249

---

I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution

2150

---

In what script is "snap$" created? In what script is the "scott/tiger" schema created?

2495

---