Database Tuning (MOSC)

MOSC Banner

SYSAUX TABLESPACE grow rapidly

edited Feb 14, 2014 3:04PM in Database Tuning (MOSC) 9 commentsAnswered

     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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center