Table des matières
Calcul de la taille des objets
Taille de chaque objet
SELECT sum(bytes)/1048576 Megs, segment_name FROM user_extents GROUP BY segment_name
Espace global occupé par les tables
SELECT sum(bytes)/1048576 Megs, segment_type FROM user_extents WHERE segment_type = 'TABLE' GROUP BY segment_type
Espace global occupé par les index
SELECT sum(bytes)/1048576 Megs, segment_type FROM user_extents WHERE segment_type = 'INDEX' GROUP BY segment_type
