database size

Posted on 2003-03-21
Medium Priority
Last Modified: 2007-10-18
how to calculate oracle database size
we created user we having sales data in it.
now how to calculate database size.when i m taking dmp it show 1 gb.
so database size is 1 gb or what.

thank u
Question by:sameerasawant
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions

Accepted Solution

bkowalski earned 200 total points
ID: 8180984
No I wouldn't say the database size is the size of the export. An export is all the data in binary format, so it's more compressed than when it's online and ready in the database.

First there's the actual disk space that is consumed by the database files which includes space for sorting and rollback segments and not just data.  This can further be looked at in terms of what the data and indexes are using, but again this will be slightly high because it will include some allocated but unused space.  Then you could determine the actual space used by data and indexes, which is a little more involved.

Which one are you after? If it's just disk space, then run this query as a dba user:

select sum(bytes) from dba_data_files;

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
Suggested Courses

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question