exec dbms_stats.alter_stats_history_retention(1);
exec DBMS_STATS.PURGE_STATS(SYSDATE-1);
set linesize 120
set pagesize 100
COLUMN "Item" FORMAT A25
COLUMN "Space Used (GB)" FORMAT 999.99
COLUMN "Schema" FORMAT A25
COLUMN "Move Procedure" FORMAT A40
SELECT occupant_name "Item",
space_usage_kbytes/1048576 "Space Used (GB)",
schema_name "Schema",
move_procedure "Move Procedure"
FROM v$sysaux_occupants
ORDER BY 1
/
exec dbms_stats.alter_stats_history_retention(1);
exec DBMS_STATS.PURGE_STATS(SYSDATE-1);
set linesize 120set pagesize 100COLUMN "Item" FORMAT A25COLUMN "Space Used (GB)" FORMAT 999.99COLUMN "Schema" FORMAT A25COLUMN "Move Procedure" FORMAT A40SELECT occupant_name "Item",space_usage_kbytes/1048576 "Space Used (GB)",schema_name "Schema",move_procedure "Move Procedure"FROM v$sysaux_occupantsORDER BY 1/Josselin Joly