Bug 491320 - Oracle 10g: SYSAUX undersized ?
Summary: Oracle 10g: SYSAUX undersized ?
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: Spacewalk
Classification: Community
Component: Server
Version: 0.4
Hardware: All
OS: Linux
low
medium
Target Milestone: ---
Assignee: Michael Mráka
QA Contact: Red Hat Satellite QA List
URL:
Whiteboard:
Depends On:
Blocks: space06
TreeView+ depends on / blocked
 
Reported: 2009-03-20 12:41 UTC by Michael Mráka
Modified: 2009-09-10 12:05 UTC (History)
1 user (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2009-09-10 12:05:42 UTC
Embargoed:

Attachments (Terms of Use)

Description Michael Mráka 2009-03-20 12:41:52 UTC 
The default sized Oracle 10g SYSAUX tablespace runs very quickly ouf of space.
Comment 1 Michael Mráka 2009-03-20 12:43:07 UTC 
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 12:50:14 UTC 
Fixed in
commit e5417ba5c9c862b7fbd466cfb82c28835cd353b4
    491320 - extended default size of SYSAUX
Comment 3 Miroslav Suchý 2009-09-10 12:05:42 UTC 
Spacewalk 0.6 released
Note You need to log in before you can comment on or make changes to this bug.