清理sysaux

教程发布:风哥 教程分类:ITPUX技术网 更新日期:2022-02-12 浏览学习:77

-- sysaux
SELECT occupant_name, schema_name,(space_usage_kbytes/1024) M FROM v$sysaux_occupants ORDER BY 3;
select SNAP_ID,BEGIN_INTERVAL_TIME from dba_hist_snapshot order by 2;
exec dbms_workload_repository.drop_snapshot_range(low_snap_id =>95,high_snap_id => 96);
select min(SNAP_ID), max(SNAP_ID) from dba_hist_snapshot;
exec dbms_workload_repository.DROP_SNAPSHOT_RANGE(LOW_SNAP_ID=>XXXXXX,HIGH_SNAP_ID=>XXXXXX);

alter tablespace SYSAUX add datafile '+DATADG' size 16g autoextend off;

本文标签:
本文标题:清理sysaux
网站声明:本文由风哥整理发布,转载请保留此段声明,本站所有内容将不对其使用后果做任何承诺,请读者谨慎使用!
【上一篇】
【下一篇】