OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » SYSAUX getting full

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

SYSAUX getting full [message #274598]

Tue, 16 October 2007 09:47

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

Report message to a moderator

Re: SYSAUX getting full [message #274711 is a reply to message #274598]

Tue, 16 October 2007 22:39

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

Change the snapshot interval and historical data retention period.

Report message to a moderator

Re: SYSAUX getting full [message #274876 is a reply to message #274598]

Wed, 17 October 2007 09:13

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.

Report message to a moderator

Re: SYSAUX getting full [message #274897 is a reply to message #274598]

Wed, 17 October 2007 10:58

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: SYSAUX getting full [message #274899 is a reply to message #274897]

Wed, 17 October 2007 11:09

vamsi316
Messages: 5
Registered: October 2007

Junior Member

Thank you! That's exactly what I was looking for.

Report message to a moderator

Previous Topic:	Oracle database startup problem
Next Topic:	ORA-342 & ORA-312

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 02 07:35:18 CST 2024