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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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

22,554 views