Home » RDBMS Server » Server Administration » SYSAUX getting full
SYSAUX getting full [message #274598] Tue, 16 October 2007 09:47 Go to next message
vamsi316
Messages: 5
Registered: October 2007
Junior Member
Hi Everyone,

I have a question that even google doesn't seem to have any answers for so was wondering if the experts here could help me out. I'm operating on Oracle 10g R2 10.2.0.3 on HP-UX Itanium. Now, I know the AWR defaults to the SYSAUX tablespace but is there a way to point it to another tablespace or is that the only way it has to be? I would like to keep SYSAUX available and my snapshot intervals are pretty big(as needed by my company). Any ideas?

Thank You,
Vamsi
Re: SYSAUX getting full [message #274711 is a reply to message #274598] Tue, 16 October 2007 22:39 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Change the snapshot interval and historical data retention period.
Re: SYSAUX getting full [message #274876 is a reply to message #274598] Wed, 17 October 2007 09:13 Go to previous messageGo to next message
vamsi316
Messages: 5
Registered: October 2007
Junior Member
Yes I did tweak the interval and retention and cut down space usage to 1/4th of the original. However, I guess a different tablespace cannot be used for AWR correct? I haven't come across that anywhere.
Re: SYSAUX getting full [message #274897 is a reply to message #274598] Wed, 17 October 2007 10:58 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
There is no way to move AWR.
Check Metalink note 287679.1, "Space Management In Sysaux Tablespace with AWR in use".
SQL> select MOVE_PROCEDURE_DESC from v$sysaux_occupants where occupant_name like '%AWR%';
MOVE_PROCEDURE_DESC
----------------------------------------------------------------
*** MOVE PROCEDURE NOT APPLICABLE ***

1 row selected.

Regards
Michel
Re: SYSAUX getting full [message #274899 is a reply to message #274897] Wed, 17 October 2007 11:09 Go to previous message
vamsi316
Messages: 5
Registered: October 2007
Junior Member
Thank you! That's exactly what I was looking for.
Previous Topic: Oracle database startup problem
Next Topic: ORA-342 & ORA-312
Goto Forum:
  


Current Time: Sun Dec 11 00:46:20 CST 2016

Total time taken to generate the page: 0.14675 seconds