If you're looking for the total size of all of the datafiles (i.e., how much disk space is occupied by the database's datafiles):

select sum(bytes) from dba_data_files;

If you're looking for the total space used by all of the segments in the database (i.e., how much data is in the database):

select sum(bytes) from dba_segments;

7 Responses so far.

  1. Cindy says:

    How database and Search Engine Differ. Click www.gofastek.com for more information.


  2. Pebbles says:

    I’m impressed. Very informative and trustworthy blog does exactly what it sets out to do. I’ll bookmark your weblog for future use.


  3. Lee Shin says:

    spot on with this write-up, i like the way you discuss the things. i'm impressed, i must say. i'll probably be back again to read more. thanks for sharing this with us.

    Lee Shin

  4. aislinn says:

    i must thank you for the efforts you've put in penning this blog. excellent blog post .


  5. sarah lee says:

    I really enjoyed reading your article. I found this as an informative and interesting post, so i think it is very useful and knowledgeable. I would like to thank you for the effort you have made in writing this article.


  6. Thanks for sharing your article and for giving us the chance to read it. It is very helpful and encouraging. Visit my site too.



  7. Santhosh says:

    Awesome post……. your article is really informative and helpful for me and other bloggers too

    Oracle Fusion SCM Online Training

Powered by Blogger.

Page Views

- Copyright © Emre Baransel - Oracle Blog -Metrominimalist- Powered by Blogger - Designed by Johanes Djogan -