Database Administration (MOSC)

MOSC Banner

Optimized Tablespace query

Kindly provide query for tablespace data by combining veiws like dba_tablespace_usage_metrics and this query:

SELECT d.name tablespace, D.mb_total,SUM (A.used_blocks * D.block_size) / 1024 / 1024 mb_used,D.mb_total - SUM (A.used_blocks * D.block_size) / 1024 / 1024 mb_freeFROM v$sort_segment A,(SELECT B.name, C.block_size, SUM (C.bytes) / 1024 / 1024 mb_totalFROM v$tablespace B, v$tempfile CWHERE B.ts#= C.ts# (+)and b.name like 'TEMP%'GROUP BY B.name, C.block_size) DWHERE A.tablespace_name (+) = D.nameGROUP by d.name, D.mb_total; 

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