Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to check exact size of database after deleting

user7316227Feb 16 2010 — edited Feb 16 2010
Hi,

oracle version : oracle 8.1.7

os : sun solaris

database size 1000gb

we have deleted millions of rows from many tables but we have't workaround to release the space (like export n import, move tables)

now how can i get the actual size of database.

i used to calcaulte database size by using select sum(bytes)/1024/1024 /1024from dba_data_files;

but in my scenerio i have deleted millions of rows how can find how much data actually consuming the space in database aka present database size.

appreciated valuable inputs.

Thanks
Prakash
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 16 2010
Added on Feb 16 2010
12 comments
2,808 views