Script - Infoindices_particionado

Monitorización de espacio de los índices particionados de la base de datos.

SET LONG 10
BREAK ON INDICE SKIP 1
SELECT
    SUBSTR(S.SEGMENT_NAME,1,15) "INDICE",
    SUBSTR(S.PARTITION_NAME,1,18) "PARTICION",
    P.HIGH_VALUE "MAXIMO",
    SUBSTR(S.TABLESPACE_NAME,1,12) "TABLESPACE",
    S.INITIAL_EXTENT/(1024) "INIT(Kb)",
    S.NEXT_EXTENT/(1024) "NEXT(Kb)",
    S.EXTENTS "NUM EXT",
    S.MAX_EXTENTS "MAX EXT",
    S.BYTES/(1024) "TAM(Kb)"
FROM DBA_SEGMENTS S,
     DBA_IND_PARTITIONS P
WHERE
    S.OWNER IN (‘USUARIO’) AND
    S.SEGMENT_NAME = P.INDEX_NAME AND
    S.PARTITION_NAME = P.PARTITION_NAME AND
    S.SEGMENT_TYPE LIKE 'INDEX%'
ORDER BY S.SEGMENT_NAME,
    P.PARTITION_POSITION;

SET LONG 1000
CLEAR BREAKS