1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
|
SELECT
SYS.DBA_TABLES.OWNER,
SYS.DBA_TABLES.TABLE_NAME,
SUM(SYS.DBA_SEGMENTS.BLOCKS),
SUM((SYS.DBA_SEGMENTS.BYTES / 1048576)) "Taille en Mo",
SUM((SYS.DBA_SEGMENTS.BYTES / 1073741824)) "Taille en Go",
SUM(SYS.DBA_SEGMENTS.EXTENTS),
SYS.DBA_TABLES.TABLESPACE_NAME
FROM
SYS.DBA_TABLES,
SYS.DBA_SEGMENTS
WHERE
( SYS.DBA_SEGMENTS.OWNER=SYS.DBA_TABLES.OWNER AND SYS.DBA_SEGMENTS.SEGMENT_NAME=SYS.DBA_TABLES.TABLE_NAME AND SYS.DBA_SEGMENTS.SEGMENT_TYPE='TABLE')
AND SYS.DBA_TABLES.OWNER='MON_SCHEMA'
AND SYS.DBA_TABLES.TABLE_NAME='MA_TABLE'
GROUP BY
SYS.DBA_TABLES.OWNER,
SYS.DBA_TABLES.TABLE_NAME,
SYS.DBA_TABLES.TABLESPACE_NAME
ORDER BY
1,
2 |
Partager