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 are the recovery models for a database? : sql server DBA

1125

---

how can you initialize log miner?

1142

---

What is fill factor? : sql server DBA

1245

---

What view(s) do you use to associate a user's SQLPLUS session with his o/s process?

2545

---

how to restore files with rman?

2300

---

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

4424

---

How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

2028

---

How would you go about verifying the network name that the local_listener is currently using?

3214

---

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

2406

---

What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?

2678

---

what is the use of ocr?

1030

---

How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?

2088

---

how can you communicate with operating system files from oracle?

1045

---

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

1009

---

how can you record information about current session?

1043

---