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/
Laisser un commentaire