SYSAUX TABLESPACE grow rapidly
Hi everbody,
My tablespace SYSAUX had almost 65GB of used in my database.
I found to table ocuppind that space, then I truncated those table
SQL> truncate table WRI$_OPTSTAT_HISTGRM_HISTORY;
Table truncated.
SQL> commit;
Commit complete.
SQL> truncate table WRI$_OPTSTAT_HISTHEAD_HISTORY;
But datafiles of SYSAUX Tablespace still having enough space and I wanted to resize it
-rw-rw---- 1 oracle oracle 9.1G Feb 13 18:25 sysaux04.dbf
-rw-rw---- 1 oracle oracle 11G Feb 13 18:26 sysaux05.dbf
-rw-rw---- 1 oracle oracle 9.6G Feb 13 18:28 sysaux03.dbf
-rw-rw---- 1 oracle oracle 13G Feb 13 18:31 sysaux06.dbf
-rw-r----- 1 oracle oracle 11G Feb 13 18:31 sysaux02.dbf
-rw-r----- 1 oracle oracle 9.6G Feb 13 18:31 sysaux01.dbf