What view would you use to determine free space in a tablespace?

Answers were Sorted based on User's Feedback



What view would you use to determine free space in a tablespace?..

Answer / guest

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

Regards
Abhinav

Is This Answer Correct ?    9 Yes 2 No

What view would you use to determine free space in a tablespace?..

Answer / shruthi

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

Is This Answer Correct ?    4 Yes 2 No

What view would you use to determine free space in a tablespace?..

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;

Is This Answer Correct ?    2 Yes 2 No

Post New Answer

More DB Administration Interview Questions

by issuing "alter tablespace begin backup;" what happens to tablespace?

5 Answers   CSC, Logica CMG,


i had backup last manday.now i need back monday to now ..how do get backup?

3 Answers   Infozech, Wipro,


Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com

0 Answers   Oracle,


Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

0 Answers  


How can you rebuild an index?

6 Answers  






What are the operating modes in which database mirroring runs? : sql server DBA

0 Answers  


What command would you use to create a backup control file?

2 Answers  


How can you enable a trace for a session?

1 Answers  


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

0 Answers  


what is ora 600?

1 Answers  


What's the benefit of "dbms_stats" over "analyze"?

1 Answers  


Which autogrowth database setting is good? : sql server DBA

0 Answers  


Categories