What query tells you how much space a tablespace named "test" is taki

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

Question Posted / narmada kumari

1 Answers
4521 Views
I also Faced
E-Mail Answers

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 are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA

0 Answers

What is the dataguard background process??

1 Answers iGate,

Where in the Oracle directory tree structure are audit traces placed?

1 Answers

Query processing is slow(eg select query)how will u solve that

3 Answers TCS,

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

0 Answers

What is transparent data encryption? : sql server DBA

0 Answers

What purpose does the model database server? : sql server DBA

0 Answers

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

3 Answers

how to copy(migrate) the database one server to another server without using expdp/impdp how it is possible.

4 Answers DELL, TCS,

Can you redefine a table online?

0 Answers Oracle,

What are the commands you'd issue to show the explain plan for "select * from dual"?

0 Answers

SUPPOSE AS A DBA YOU CREATED ONE USER BY DEFAULT HOW MANY PRIVILIZES WILL COME TO USER & WHERE CAN YOU SEE THAT PRIVILIZES.

4 Answers Cognizant,

For more DB Administration Interview Questions Click Here