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
4486 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

How would you go about increasing the buffer cache hit ratio?

2 Answers

what are the differences of where and if in SAS?

0 Answers

How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA

0 Answers

why we use cursors

1 Answers

What command would you use to encrypt a PL/SQL application?

1 Answers

What is the default port no on which sql server listens? : sql server DBA

0 Answers

what r the types of backup?

5 Answers CSC,

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

0 Answers Patni,

How do you open a cluster administrator? : sql server DBA