How should I size the SYSAUX tablespace properly?
Size estimates can be obtained differently based on two following scenarios: i) Scenario A: You are creating a new SYSAUX tablespace (i.e., either during the creation of a new Oracle 10g database or migrating from a release prior to Oracle 10g), you should use the following rough guidelines. For a small system allocate 500MB. A system with 2 CPUs, average of 10 active* sessions, and 500 user objects (tables and indexes) is considered a small system. For a medium size system allocate 2 GB of space. A system with 8 CPUs, average of 20 active sessions, and 5,000 user objects (tables/indexes) is considered a mid-size system. For a large system, allocate 5 GB of space. A system with 32 CPUs, average of 100 active sessions, and 50,000 user objects (tables/indexes) is considered a large system. Note: An active session is a session that is executing a call (i.e., doing work). This is not to be confused with connected sessions, which are basically the number of logons to the database. ii) Scena
