Posts

Showing posts from August, 2014

Oracle 11g:SYSAUX Tablespace purging when abnormally increases by size

Image
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 occupies 93.1 MB ( 0.3% )   | Schema MDSYS occupies 56.1 M