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 list real space usage of the tables in a schema?

TamasSzecsyMar 20 2012 — edited Mar 20 2012

Hi,

I would like to know how much disk space does may schema (tables + indexes) are really using? I would like to pack my schema with all it's data into an Oracle XE instance. XE has a 4 GB database size limit, so I would like to know if this is possible at all.

Could some one please link me a to script that show the space used by a schema's tables and indexes? Allocated extent is misleading, since an almost empty extent is using space, although there is hardly any data in it.

Thanks in advance.

Tamas

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 17 2012

Added on Mar 20 2012

#dba, #general-database-discussions

5 comments

23,214 views