Oracle 11g:SYSAUX Tablespace purging when abnormally increases by size
Oracle 11g:SYSAUX Tablespace purging when abnormally increases by size It is very obvious when we enable feature of sql profiler by OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES or increases the retention period of awr reports. We can get the all info of space utilization of sysaux tablespace by awrinfo.sql . Collect the space occupied by objects. Report o/p look something like this... ############################## ######################### (I) AWR Snapshots Information ############################## ########################## ****************************** *********************** (1a) SYSAUX usage - Schema breakdown (dba_segments) ****************************** *********************** | | Total SYSAUX size 36,037.3 MB ( 88% of 40,937.9 MB MAX with AUTOEXTEND OFF ) | | Schema SYS occupies 35,717.3 MB ( 99.1% ) | Schema SYSMAN occupies 123.3 MB ( 0.3% ) | Schema SYSTEM ...