Bug 491320
| Summary: | Oracle 10g: SYSAUX undersized ? | ||
|---|---|---|---|
| Product: | [Community] Spacewalk | Reporter: | Michael Mráka <mmraka> |
| Component: | Server | Assignee: | Michael Mráka <mmraka> |
| Status: | CLOSED CURRENTRELEASE | QA Contact: | Red Hat Satellite QA List <satqe-list> |
| Severity: | medium | Docs Contact: | |
| Priority: | low | ||
| Version: | 0.4 | CC: | jmatthew |
| Target Milestone: | --- | ||
| Target Release: | --- | ||
| Hardware: | All | ||
| OS: | Linux | ||
| Whiteboard: | |||
| Fixed In Version: | Doc Type: | Bug Fix | |
| Doc Text: | Story Points: | --- | |
| Clone Of: | Environment: | ||
| Last Closed: | 2009-09-10 12:05:42 UTC | Type: | --- |
| Regression: | --- | Mount Type: | --- |
| Documentation: | --- | CRM: | |
| Verified Versions: | Category: | --- | |
| oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | |
| Cloudforms Team: | --- | Target Upstream Version: | |
| Embargoed: | |||
| Bug Depends On: | |||
| Bug Blocks: | 456554 | ||
|
Description
Michael Mráka
2009-03-20 12:41:52 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 Fixed in
commit e5417ba5c9c862b7fbd466cfb82c28835cd353b4
491320 - extended default size of SYSAUX
Spacewalk 0.6 released |