Taille de chaque objet

1
2
3
SELECT sum(bytes)/1048576 Megs, segment_name
FROM user_extents
GROUP BY segment_name

Espace global occupé par les tables

1
2
3
4
SELECT sum(bytes)/1048576 Megs, segment_type
FROM user_extents
WHERE segment_type = 'TABLE'
GROUP BY segment_type

Espace global occupé par les index

1
2
3
4
SELECT sum(bytes)/1048576 Megs, segment_type
FROM user_extents
WHERE segment_type = 'INDEX'
GROUP BY segment_type