1.2 KiB
BEGIN DBMS_WORKLOAD_REPOSITORY.modify_snapshot_settings( retention => 7 * 24 * 60, -- Retain snapshots for 7 days interval => 60 -- Collect snapshot every 60 minutes ); END; /
BEGIN
DBMS_WORKLOAD_REPOSITORY.modify_snapshot_settings(
retention => 7 * 24 * 60,
interval => 60
);
END;
/
EXEC DBMS_STATS.alter_stats_history_retention(RETENTION => 7);
4gu1ln
SELECT table_name, bytes / 1024 / 1024 AS size_mb, blocks, extents FROM dba_segments WHERE segment_type = 'TABLE' AND tablespace_name = 'USERS' ORDER BY bytes DESC;
SELECT segment_name AS table_name, bytes / 1024 / 1024 AS size_mb, blocks, extents FROM dba_segments WHERE segment_type = 'TABLE' AND tablespace_name = 'USERS' ORDER BY bytes DESC;
ALTER TABLE enforce_center.SHR_DATA_SWITCH_LOGS ENABLE ROW MOVEMENT; ALTER TABLE enforce_center.SHR_DATA_SWITCH_LOGS SHRINK SPACE;
SELECT segment_name AS index_name, owner, bytes / 1024 / 1024 AS size_mb, blocks, extents FROM dba_segments WHERE segment_type = 'INDEX' AND tablespace_name = 'ENFORCE_CENTER' ORDER BY size_mb DESC;
ALTER INDEX ENFORCE_CENTER.PERSON_INDEX REBUILD;
DROP TABLE ENFORCE_CENTER.PATROL_DOC_copy1 PURGE;