• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1558
  • Last Modified:

database size

hi
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
0
sameerasawant
Asked:
sameerasawant
1 Solution
 
bkowalskiCommented:
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;
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now