SCRIPTS PLSQL/SQL DIVERSOS.

VERIFICA MAX EXTENTS

SELECT OWNER, SEGMENT_NAME, SEGMENT_TYPE, EXTENTS, MAX_EXTENTS
FROM DBA_SEGMENTS
WHERE EXTENTS >= (MAX_EXTENTS*50/100);