Muneer's Database Administration Blog

Oracle DBA Knowledge Portal

About this Blog

4 Comments

I will be using this portal to post the knowledge based articles regarding Administration of various Oracle enterprise products e.g. Database, E-Business Suite, Application Server etc.

4 Responses to About this Blog

umair January 3, 2011 at 4:26 PM
Hello,
Kindly tell Tablespace Free Space script,I am very thankful to you

Thanks,
Umair

Reply
Muneer Alam January 3, 2011 at 5:09 PM
Dear Umair,

Do you have any questions about the script ?

Please let me know.

Reply
- umair January 3, 2011 at 5:36 PM
  Hello Muneer,
  Thanks for reply,Kindly tell me query to find out Tablespace free(MB,G) and used space along with it’s datafile.
  
  Thanks,
  Umair
  
  Reply
  - Muneer Alam January 3, 2011 at 5:47 PM
    SQL> select TABLESPACE_NAME,round(sum(BYTES/1024/1024),2) FREE_SPACE_MB, round(sum(BYTES/1024/1024/1024),2) FREE_SPACE_GB from dba_free_space group by TABLESPACE_NAME;
    
    Dear Umair, the above query involves a group function, so you can not select the datafiles with tablespaces. For that, you can separately query the datafiles for various tablespaces from dba_data_files view.
    
    Thanks.