Sysaux Tablespace grows rapidly.
Hey,
I am working on a Oracle EBS R12 environment and the database is 11g 11.1.0.7.0 on a Linux Platform.
The issue at hand is that the Sysaux Tablespace is growing rapidly.
The Physical usage is as shown below,
| Name | Size, MB | Used, MB |
| SYSAUX | 105,401.00 | 101,330.88 |
I have run the awrinfo.sql and few of my observations are,
*****************************************************
(1a) SYSAUX usage - Schema breakdown (dba_segments)
*****************************************************
|
| Total SYSAUX size 101,326.3 MB ( 44% of 229,375.9 MB MAX with AUTOEXTEND ON )
|
| Schema SYS occupies 101,240.6 MB ( 99.9% )
| Schema XDB occupies 54.9 MB ( 0.1% )
| Schema OLAPSYS occupies 15.6 MB ( 0.0% )
| Schema SYSTEM occupies 14.7 MB ( 0.0% )
| Schema DMSYS occupies 0.3 MB ( 0.0% )
| Schema TSMSYS occupies 0.3 MB ( 0.0% )
********************************************************
(1b) SYSAUX occupants space usage (v$sysaux_occupants)