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

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;

6 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

Powered by Blogger.

Page Views

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