Database Administration (MOSC)

MOSC Banner

Allocated and Used MB space for Table and Index

edited Feb 10, 2010 8:52AM in Database Administration (MOSC) 3 commentsAnswered
 I am looking for a query which could give accurate/robost result on how much space is allocated and used for specific Table or Index. I have some queries running against DBA_SEGMENTS and DBA_TABLES but not sure they are accurate.  The tables and index are being analyzed.

Appreciate your assistance.

Thanks,

Hemant

>>>> Anyone who could provide accurate script to calculate used and allocated space for Table/Tables. The one I have calcualtes used by row number etc.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center