RE: Oracle 10g Rel2 - SYSMAN Tablespace Growing

            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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Kellyn Pedersen Sent: Thursday, May 28, 2009 12:19 AM
To: oracle-l_at_freelists.org; joel.wittenmyer_at_templarstable.com 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_at_templarstable.com <joel.wittenmyer_at_templarstable.com> wrote:         

        From: joel.wittenmyer_at_templarstable.com <joel.wittenmyer_at_templarstable.com>

	Subject: Re: Oracle 10g Rel2 - SYSMAN Tablespace Growing
	To: oracle-l_at_freelists.org
	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

	>> ----------------------------------------

	
	
	
	
	--
	http://www.freelists.org/webpage/oracle-l
	
	

 

--
http://www.freelists.org/webpage/oracle-l