Harvest

TECH TIP: How to get Harvest Tablespace Usage and Freespace

  • 1.  TECH TIP: How to get Harvest Tablespace Usage and Freespace

    Posted 04-07-2016 03:03 PM

    Question:  How do I get a report from my Oracle database on the table space usage and free space?

     

    Solution: Here is an example of running that query against your Oracle database in the CA DBrowse utility:

     

    Here is the example query for copy/paste:

     

    // Oracle

    select

       fs.tablespace_name                                  "Tablespace",

       (df.totalspace - fs.freespace)                     "Used MB",

       fs.freespace                                               "Free MB",

       df.totalspace                                               "Total MB",

       round(100 * (fs.freespace / df.totalspace)) "Pct. Free"

    from

       (select

          tablespace_name,

          round(sum(bytes) / 1048576) TotalSpace

       from

          dba_data_files

       group by

          tablespace_name

       ) df,

       (select

          tablespace_name,

          round(sum(bytes) / 1048576) FreeSpace

       from

          dba_free_space

       group by

          tablespace_name

       ) fs

    where

       df.tablespace_name = fs.tablespace_name;