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

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;

10 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. aislinn says:

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

    www.n8fan.net

  4. Unknown 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

  5. 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

  6. Very interesting blog Awesome post. your article is really informative and helpful for me and other bloggers too
    Oracle Fusion HCM Online Training

  7. shivani says:

    Thanks for sharing a useful information.. we have learnt so much information from your blog..... keep sharing
    Oracle Fusion Financials Online Training
    Oracle Fusion HCM Online Training
    Oracle Fusion SCM Online Training

  8. Anonymous says:

    Thank you for sharing such a nice and interesting blog with us. I have seen that all will say the same thing repeatedly. But in your blog, I had a chance to get some useful and unique information.

    sem training in hyderabad
    seo training in hyderabad
    SMM Training In Hyderabad

  9. Nice Blog Really excellent information and thank you for giving your valuable information


    Big Data and Hadoop Online Training
    Big Data Hadoop Training
    Hyderabad

Powered by Blogger.

Page Views

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