RE: Oracle 10g Rel2 - SYSMAN Tablespace Growing
- From: "Mudhalvan Moovarkku" <moovarkku.mudhalvan@xxxxxxxxxxxxxxxx>
- To: <kjped1313@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>, <joel.wittenmyer@xxxxxxxxxxxxxxxxx>
- Date: Thu, 28 May 2009 10:08:34 +0900
Hi Kellyn,
Thanks for your mail.
Yes I have checked as advised by freelist DBA and Changed to
0.
I hope my issue has been closed for SM/OPTSTAT
What about SM/AWR. Is any one have idea
Regards
Mudhalvan M.M
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Kellyn Pedersen
Sent: Thursday, May 28, 2009 12:19 AM
To: oracle-l@xxxxxxxxxxxxx; joel.wittenmyer@xxxxxxxxxxxxxxxxx
Subject: Re: Oracle 10g Rel2 - SYSMAN Tablespace Growing
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:
