作者:巴萨小Q | 来源:互联网 | 2023-10-11 22:51
SELECTowner,tablespace_name,ROUND(SUM(BYTES)10241024,2)USED(M)FROMdba_segmentsGROUPBYow
SELECT owner, tablespace_name, ROUND (SUM (BYTES) / 1024 / 1024, 2) "USED(M)"
FROM dba_segments
GROUP BY owner, tablespace_name
ORDER BY SUM (BYTES) DESC;