--------------------------

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;

13 Responses so far.

  1. Cindy says:

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

    Cindy
    www.gofastek.com

  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.

    Pebbles
    www.joeydavila.net

  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
    www.trendone.net

  4. aislinn says:

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

    www.n8fan.net

  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.


    joselle
    edupdf.org

  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.

    triciajoy.com

    www.triciajoy.com

  7. Santhosh says:

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

    Oracle Fusion SCM Online Training

  8. Charan says:

    I would like to thank you for the efforts you have made in writing this article. I am hoping the same best work from you in the future as well.

    Oracle Fusion HCM Online Training

  9. sushma says:

    Hey Really Thanks for sharing the best information regarding category, hope you will write more great blogs.
    Oracle Fusion Financials Online Training

  10. raju says:

    Thank you for sharing such a nice and interesting blog.
    Oracle Fusion Financials Online Training

  11. This is the correct weblog for anybody who wants to seek out out about this topic. You notice so much its virtually laborious to argue with you (not that I actually would need…HaHa). You definitely put a brand new spin on a topic thats been written about for years. Great stuff, simply great! online casinos for us players

  12. Really excellent information and thank you for giving your valuable information

    Oracle Fusion SCM Online Training

  13. Thank you for sharing such a nice and interesting blog and really very helpful article

    Oracle Fusion Financials Online Training

Powered by Blogger.

Page Views

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