Bug 491320 - Oracle 10g: SYSAUX undersized ?
Oracle 10g: SYSAUX undersized ?
Status: CLOSED CURRENTRELEASE
Product: Spacewalk
Classification: Community
Component: Server (Show other bugs)
0.4
All Linux
low Severity medium
: ---
: ---
Assigned To: Michael Mráka
Red Hat Satellite QA List
:
Depends On:
Blocks: space06
  Show dependency treegraph
 
Reported: 2009-03-20 08:41 EDT by Michael Mráka
Modified: 2009-09-10 08:05 EDT (History)
1 user (show)

See Also:
Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of:
Environment:
Last Closed: 2009-09-10 08:05:42 EDT
Type: ---
Regression: ---
Mount Type: ---
Documentation: ---
CRM:
Verified Versions:
Category: ---
oVirt Team: ---
RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: ---


Attachments (Terms of Use)

  None (edit)
Description Michael Mráka 2009-03-20 08:41:52 EDT
The default sized Oracle 10g SYSAUX tablespace runs very quickly ouf of space.
Comment 1 Michael Mráka 2009-03-20 08:43:07 EDT
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 
5 GB
Comment 2 Michael Mráka 2009-03-20 08:50:14 EDT
Fixed in
commit e5417ba5c9c862b7fbd466cfb82c28835cd353b4
    491320 - extended default size of SYSAUX
Comment 3 Miroslav Suchý 2009-09-10 08:05:42 EDT
Spacewalk 0.6 released

Note You need to log in before you can comment on or make changes to this bug.