Muneer's Database Administration Blog

Oracle DBA Knowledge Portal

About this Blog

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

  1. umair January 3, 2011 at 4:26 PM

    Hello,
    Kindly tell Tablespace Free Space script,I am very thankful to you

    Thanks,
    Umair

  2. Muneer Alam January 3, 2011 at 5:09 PM

    Dear Umair,

    Do you have any questions about the script ?

    Please let me know.

    • 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

      • 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.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 59 other followers

%d bloggers like this: