 SYSAUX [message #354525] |
Mon, 20 October 2008 03:19  |
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 #354807 is a reply to message #354548] |
Tue, 21 October 2008 06:35  |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
