Red Hat Bugzilla – Bug 491320
Oracle 10g: SYSAUX undersized ?
Last modified: 2009-09-10 08:05:42 EDT
The default sized Oracle 10g SYSAUX tablespace runs very quickly ouf of space.
From oracle doc:
A typical system with an average of 10 concurrent active sessions may require
approximately 200 to 300 MB of space for its AWR data.
The following table provides guidelines on sizing the SYSAUX tablespace based
on the system configuration and expected load.
Parameter/Recommendation Small Medium Large
Number of CPUs 2 8 32
Number of concurrently active sessions 10 20 100
Number of user objects: tables and indexes 500 5,000 50,000
Estimated SYSAUX size at steady state with default configuration 500 MB 2 GB
491320 - extended default size of SYSAUX
Spacewalk 0.6 released