Le Blog de DiabloCorps

Espace disque occupé par les objets Oracle :

SELECT
    segment_name "TABLE"
    , SUM(BYTES) /1024 || 'Ko' "Taille"
    , blocks "Blocs"
    , tablespace_name "TABLESPACE"
FROM
    dba_segments
WHERE
                 segment_type = 'TABLE'
AND            OWNER = 'FD'
GROUP BY    segment_name, tablespace_name, blocks
ORDER BY    segment_name ;

Espace disque occupé par toutes les tables d’un schéma :

SELECT
    SUM(BYTES) /1024 /1024 || 'Mo' "Taille"
    , SUM(blocks) "Blocs"
FROM
    dba_segments
WHERE
    segment_type = 'TABLE'
AND            OWNER = 'FD'
GROUP BY    OWNER ;

Espace disque occupé par tous les schémas :

SELECT
    SUM(BYTES) /1024 /1024 || 'Mo' "Taille"
    , SUM(blocks) "Blocs"
FROM
    dba_segments ;