Calcul de la taille des objets

Taille de chaque objet

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

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

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