Script - Infoindices

Monitorización de espacio de los índices del usuario con el que estamos conectados a la base de datos.

SET LINESIZE 1000

PROMPT INDICES

SELECT
SUBSTR(T.INDEX_NAME,1,35) "INDICE",
SUBSTR(T.TABLESPACE_NAME,1,15) "TABLESPACE",
T.INITIAL_EXTENT/1024 "INIT(Kb)",
T.NEXT_EXTENT/1024 "NEXT(Kb)",
COUNT(*) "NUM EXT",
T.MAX_EXTENTS "MAX EXT",
SUM(BYTES)/1024 "TAM(Kb)"
FROM USER_INDEXES T, USER_EXTENTS E
WHERE T.INDEX_NAME=E.SEGMENT_NAME
GROUP BY T.INDEX_NAME, T.TABLESPACE_NAME, T.INITIAL_EXTENT, T.NEXT_EXTENT,T.MAX_EXTENTS
ORDER BY 1,T.TABLESPACE_NAME,T.INDEX_NAME;


SET LINESIZE 1000