1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Query to find out space information for given table.

Discussion in 'SQL PL/SQL' started by Amit.Sagpariya, Mar 2, 2009.

  1. Amit.Sagpariya

    Amit.Sagpariya Active Member

    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    55
    Hi All,

    Can someone have query to find out the space information for a given table. For example, if i pass the table name, it should return me total allocated space, Used Space & Free Space for a given table.?

    Thank you in advance for you help.
     
  2. simply_dba

    simply_dba Forum Advisor

    Messages:
    95
    Likes Received:
    5
    Trophy Points:
    140
    Location:
    Kolkata, India
    have a look at dba_segments and dba_extents and try out the query on your own.