How much space used by a schema
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: How much space used by a schema

  1. #1
    Join Date
    Aug 2000
    Posts
    5
    Hello All!

    I have another question for you.. probably a newbie question too... what is a good statement to use to find out how much space is used by a particular schema?

    Thanks

  2. #2
    Join Date
    Jun 2000
    Posts
    417
    I think "select sum(bytes) from dba_segments where owner='SCHEMA'" should work.

  3. #3
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    Find out what are all the data and index tablespaces used for that particular schema(If you have designed your schema like that) and calculate the total. Get the information you wanted from DBA_TABLESPACES and DBA_FREE_SPACE views.

    You can see the size of tablespace if you are using Oracle Enterprize Manager/ any other third party enterprize management tool.

    Powneil statement works. Thats Quick tip. thanks

    [Edited by sreddy on 01-03-2001 at 03:09 PM]

  4. #4
    Join Date
    Aug 2000
    Posts
    5
    thanks for your help guys!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width