Re: Oracle 10g Rel2 - SYSMAN Tablespace Growing
- From: Kellyn Pedersen <kjped1313@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx, joel.wittenmyer@xxxxxxxxxxxxxxxxx
- Date: Wed, 27 May 2009 08:19:13 -0700 (PDT)
Even though you say you have "disabled" it, have you verified that the
retention is not still being held for statistics? What objects are using up
the space on the SYSAUX table and I would check the retention:
select DBMS_STATS.GET_STATS_HISTORY_RETENTION from dual;
And if your space is being utilized by the SYS.WRI$_OPSTAT** tables/indexes, I
would set the retention to 0, even if you have disabled it, I've seen odder
things with this, (usually not with release 2, but never say never, I've
learned...)
exec DBMS_STATS.ALTER_STATS_HISTORY_RETENTION(0);
Good luck,
Kellyn
--- On Wed, 5/27/09, joel.wittenmyer@xxxxxxxxxxxxxxxxx
<joel.wittenmyer@xxxxxxxxxxxxxxxxx> wrote:
From: joel.wittenmyer@xxxxxxxxxxxxxxxxx <joel.wittenmyer@xxxxxxxxxxxxxxxxx>
Subject: Re: Oracle 10g Rel2 - SYSMAN Tablespace Growing
To: oracle-l@xxxxxxxxxxxxx
Date: Wednesday, May 27, 2009, 8:48 AM
Nevermind. I see you disabled AWR. I'll have to learn to read more
carefully / thoroughly.
>> Dear DBAs,
>>
>> I have disabled the SM/AWR and SM/OPTSTAT. But still SYSAUX is
>> growing. Can anyone help me to find out why it is still growing
....
>>
>> Best Regards,
>> M.Moovarkku Mudhalvan
>> ----------------------------------------
--
//www.freelists.org/webpage/oracle-l
Other related posts:
