1. Categories >> Software >> Databases >> DB Administration
  2. Suggest New Category

What query tells you how much space a tablespace named
"test" is taking up, and how much space is remaining?

Question Posted / narmada kumari


What query tells you how much space a tablespace named "test" is taking up, and how much ..

Answer / jaleel

TO CHECK TAKINGUP SPACE
SQL> select sum(bytes)/1024/1024 "TABLESPACESIZE:MB"
from dba_segments where tablespace_name='TEST';

TO CHECK FREE SPACE
SQL> select sum(bytes)/1024/1024 "TABLESPACESIZE:MB"
from dba_free_space where tablespace_name='TEST';

Is This Answer Correct ?    3 Yes 0 No

Post New Answer

More DB Administration Interview Questions

what is the differnce between process and thread ?

1 Answers   IBM,

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

0 Answers  

what r the types of backup?

5 Answers   CSC,

What happens on checkpoint? : sql server DBA

0 Answers  

How to make a replica of existing oracle server to another server?

3 Answers  




Where would you look for errors from the database engine?

0 Answers   IBM,

how do see how much space is used and free in a tablespace

2 Answers   Genpact,

Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

0 Answers  

what is incremental checkpoint?

1 Answers   CTS,

What are the ways tablespaces can be managed and how do they differ?

2 Answers   IBM,

What is the dataguard background process??

1 Answers   iGate,

what is rebuild index??

2 Answers   IBM, Sapient,

For more DB Administration Interview Questions Click Here
Categories