Skip to content
Vinod Surendran

Vinod Surendran

Programmer, Photographer, Human

Menu
  • About
Menu
  • About

How to get the TableSpace usage in Oracle

Posted on May 14, 2009May 14, 2009 by Vinod Surendran

I think you will spend 41 seconds reading this post

To get the table space usage in oracle use this query

select    a.TABLESPACE_NAME,
ROUND(a.BYTES/1024000) “Used (MB)”,
ROUND(b.BYTES/1024000) “Free (MB)”,
round(((a.BYTES-b.BYTES)/a.BYTES)*100,2) “% USED”
from
(
select  TABLESPACE_NAME,
sum(BYTES) BYTES
from    dba_data_files
group   by TABLESPACE_NAME
)
a,
(
select  TABLESPACE_NAME,
sum(BYTES) BYTES ,
max(BYTES) largest
from    dba_free_space
group   by TABLESPACE_NAME
)
b
where    a.TABLESPACE_NAME=b.TABLESPACE_NAME
and a.TABLESPACE_NAME like ‘%’
order      by ((a.BYTES-b.BYTES)/a.BYTES) desc ;

If You want to list a particular table space  replace  a.TABLESPACE_NAME like ‘%’ with a.TABLESPACE_NAME like ‘MY_TABLE_SPACE’

To get the temporary tablespace usuage use this query

SELECT tablespace_name, SUM(bytes_used), SUM(bytes_free)
FROM V$temp_space_header
GROUP BY tablespace_name;

Posted in OracleTagged Oracle

Post navigation

How to Get the Locked Tables List In Oracle

Related Post

  • How to get the TableSpace usage in Oracle How to export sequences using sql
  • How to get the TableSpace usage in Oracle How to track queries in oracle ..
  • How to get the TableSpace usage in Oracle How to Get the Locked Tables List In Oracle

3 thoughts on “How to get the TableSpace usage in Oracle”

  1. Dee Mcdaris says:
    October 8, 2011 at 10:08 pm

    Read many articles, this is the best I have seen the article.

  2. hostgator vps coupon code says:
    November 5, 2012 at 9:40 am

    Some genuinely nice and useful info on this site, also I believe the design and style holds great features.

  3. Hostgator 1 cent coupon says:
    November 7, 2012 at 12:10 pm

    Wohh exactly what I became looking for, thankyou with regard to submitting . “Talent grows throughout pleasure, persona in the complete existing involving man life.” by simply Johann Wolfgang von Goethe.

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Recent Posts

  • Windows Terminal April 24, 2020
  • Eureka and AWS ECS May 2, 2019
  • Build your nodeJS Application in a modular way October 26, 2017
  • JWT – Security with Simplicity March 31, 2017

Recent Comments

  • Vinod Surendran on Build your nodeJS Application in a modular way
  • Bruce on Build your nodeJS Application in a modular way
  • Sujesh on My experiments with IoT – “Meeting with Pi”
  • Hostgator 1 cent coupon on How to get the TableSpace usage in Oracle
  • hostgator vps coupon code on How to get the TableSpace usage in Oracle

Tags

android android applications applications Arduino asianet dataline butteryfly chrome evdo Experiments firefox General google Hello World HTC Htc legend Ideas industry IOT Legend Linux linux ubuntu login microservice Mobile modem movie player Netflix node nodeJS NPM one click Oracle personal photo Raspberry Pi rooting script Scripts story Tips and Tricks tweaks ubuntu unix Update Windows

Archives

Categories

  • Android (4)
  • General (24)
    • Status Updates (8)
  • IoT (1)
  • Linux (4)
  • Microservice (1)
  • Mobile (5)
  • nodeJS (1)
  • Oracle (4)
  • Photography (1)
  • Tips and Tricks (3)
  • Windows (2)

Tags

android android applications applications Arduino asianet dataline butteryfly chrome evdo Experiments firefox General google Hello World HTC Htc legend Ideas industry IOT Legend Linux linux ubuntu login microservice Mobile modem movie player Netflix node nodeJS NPM one click Oracle personal photo Raspberry Pi rooting script Scripts story Tips and Tricks tweaks ubuntu unix Update Windows

History

  • April 2020 (1)
  • May 2019 (1)
  • October 2017 (1)
  • March 2017 (2)
  • February 2017 (2)
  • January 2017 (2)
  • July 2015 (1)
  • July 2014 (3)
  • January 2013 (4)
  • October 2011 (1)
  • September 2011 (1)
  • May 2011 (2)
  • December 2010 (4)
  • August 2010 (2)
  • July 2010 (1)
  • June 2010 (2)
  • May 2010 (2)
  • April 2010 (4)
  • December 2009 (2)
  • July 2009 (1)
  • May 2009 (6)

Categories

  • Android (4)
  • General (24)
    • Status Updates (8)
  • IoT (1)
  • Linux (4)
  • Microservice (1)
  • Mobile (5)
  • nodeJS (1)
  • Oracle (4)
  • Photography (1)
  • Tips and Tricks (3)
  • Windows (2)
Theme Design & Developed By OpenSumo
  • About