Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Release SYSAUX tablespace - Shirnk SYS.WRH$_ACTIVE_SESSION_HISTORY

Hassan R. KhanJun 10 2010 — edited Jun 10 2010

Hi All:

We are using Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 and OS is AIX 5.3

The "SYSAUX" table space is growing to 95%. While checking the object size we found table "WRH$_ACTIVE_SESSION_HISTORY" size is 4.69 GB. I would like to know that is there any way to shrink this table and reduce the tablespace "SYSAUX" size.

Regareds,

Hassan

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 8 2010

Added on Jun 10 2010

#general-database-discussions

12 comments

8,852 views