Home » RDBMS Server » Server Administration » SYSAUX (Oracle 10g OS solaris 10)
icon1.gif  SYSAUX [message #354525] Mon, 20 October 2008 03:19 Go to next message
sailesh
Messages: 72
Registered: September 2007
Location: MAURITIUS
Member
Dear all,

I have an oracle 10g db install on Solaris 10 Sparc. I have noticed that SYSAUX tablespace keeps on decreasing everyday. Furthermore, i have configured AWR to generate reports for errors and SQL statements.

Please advise.
Re: SYSAUX [message #354533 is a reply to message #354525] Mon, 20 October 2008 03:44 Go to previous messageGo to next message
Michel Cadot
Messages: 68722
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Is there any question in your post?

By the way, what does "SYSAUX tablespace keeps on decreasing" mean?

Regards
Michel
Re: SYSAUX [message #354540 is a reply to message #354525] Mon, 20 October 2008 04:15 Go to previous messageGo to next message
ora110
Messages: 42
Registered: September 2007
Location: China
Member
increasing or decreasing?
Re: SYSAUX [message #354546 is a reply to message #354540] Mon, 20 October 2008 04:34 Go to previous messageGo to next message
sailesh
Messages: 72
Registered: September 2007
Location: MAURITIUS
Member
The tablespace everyday increases by 10MB.

Thanks
Re: SYSAUX [message #354548 is a reply to message #354546] Mon, 20 October 2008 04:37 Go to previous messageGo to next message
Michel Cadot
Messages: 68722
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Query v$sysaux_occupants each day to know who is using space.

Regards
Michel
Re: SYSAUX [message #354807 is a reply to message #354548] Tue, 21 October 2008 06:35 Go to previous message
SandLake
Messages: 3
Registered: October 2008
Junior Member
I had a similiar problem and on investigtion AWR was producing reports (something like) every half hour and retaining them for 10 days, I changed it to every 2 hours and retain them for 4 days.

The SYSAUX tablespace was reporting a decrease in freespace of almost 1 percent each day, it has now stabilised at 29-30 percent and has stayed that way for over a year
Previous Topic: Oracle erros-please help!
Next Topic: WEBUTIL_C_API.REBIND_PARAMETER will not work
Goto Forum:
  


Current Time: Mon Dec 09 20:13:51 CST 2024