Solution : https://service.sap.com/sap/support/notes/600141 (SAP Service marketplace login required)
Summary :
This SAP Note provides documentation for the Automatic Undo Management (AUM) feature in Oracle9i, geared towards database administrators transitioning from manual to automatic management of rollback segments. It outlines the structure, support through BR*Tools, general recommendations, and details of AUM, including description, advantages, recommendations, and special features. Key components such as the undo_management, undo_tablespace, and undo_retention parameters are discussed. The note emphasizes AUM’s benefits in dynamic configuration and simplified administration, reducing manual interventions and enhancing system management efficiency. Recommendations for implementing AUM in new Oracle installations and SAP systems are provided to optimize performance and consistency.
Key words :
tablespace_name status contents extent_man allocatio segment---------------- --------- --------- ---------- --------- ------psapundo online undo local system manualpsapundo2 online undo local system manual aum-administration creating, br toolsgeneral recommendationaum - descriptionaum - advantagesaum - recommendationsaum - special featuresaum - special features, delete temporarily created rollback segment sql>alter rollback segment rbs_temp offline, sql>show parameter undo sql>show parameter rollback_segments sql>select segment_name, current undo management status sql>show parameter undo sql>select segment_name, current undo management mode sql>show parameter undo sql>select segment_name, sql>alter system reset undo_tablespace scope = spfile sid = ' ', sql>alter system reset transactions_per_rollback_segment scope = spfile sid = ' ', sql>alter system reset max_rollback_segments scope = spfile sid=' ', sql>alter system reset rollback_segments scope = spfile sid = ' '
Related Notes :
| 1475173 | Contention with auto-tuned undo retention |
| 1035137 | Oracle Database 10g: Automatic Undo Retention |
| 937492 | FAQ: Oracle Flashback |
| 830576 | Parameter recommendations for Oracle 10g |
| 706625 | Oracle9i: Locally managed SYSTEM tablespace |
| 598678 | Oracle 9i: New functions |
| 534036 | SAP LT: System settings for conversions |
| 185822 | ora-1555 - cause and action |
| 3807 | Error messages regarding rollback and undo segments |