Answer / guest

It is dba_free_space which gives u the info about free
space in any tablespace

Regards
Abhinav

Answer / shruthi

It is sm$ts_free.......

Answer / rajesh naidu

SELECT TABLESPACE_NAME,SUM(BYTES/1024/1024) FROM
DBA_FREE_SPACE GROUP BY TABLESPACE_NAME;

AND THE VIEW IS DESC DBA_FREE_SPACE;

What is the default fill factor value? : sql server DBA

0 Answers  

---

You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

0 Answers  

---

What background process refreshes materialized views?

2 Answers   Accenture, FLSmidth,

---

Explain the difference between ARCHIVELOG mode and NOARCHIVELOG mode and the benefits and disadvantages to each.

5 Answers  

---

how can you connect from 10g user to 11g user??

0 Answers   HP,

---

How do you switch from an init.ora file to a spfile?

4 Answers   TCS,

---

what is meant by gateway

1 Answers   IBM,

---

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

0 Answers  

---

A lady is trying to pick gloves and hats from her wardrobe in the dark. She has 22 white and 33 green ones. She wants to pick a pair of gloves of white and green. How many tries before she gets it right?

1 Answers   TCS,

---

what is the use of ocr?

0 Answers   Oracle,

---

what functionality does oracle provide to secure sensitive information?

0 Answers   Oracle,

---

what is grd?

0 Answers   Oracle,

---