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;
0