SQL Language (MOSC)

MOSC Banner

actual size

edited Jul 11, 2012 9:34PM in SQL Language (MOSC) 3 commentsAnswered
Hi,Is it possible to use a single SQL query to return the actual (used) size of a single table and its related indexes including lob index and lob segments
without using DBMS_SPACE?

requirements
1. Returns
    a. table used size
    b. indexes used size
    c. lob index used size
    d. log segment used size
2. No user defined function used.
3. No DBMS_SAPCE because it won't provide combined used size in one statement

Just ask the possibility. if yes then how?
I know it sounds ridiculous though.
 
Thanks,
Sha

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