Solution : https://service.sap.com/sap/support/notes/3807 (SAP Service marketplace login required)
Summary :
SAP Note provides guidelines for addressing Oracle database errors arising from transactions involving various rollback segments and tablespaces. Key errors highlighted include ORA-01552 through ORA-30036, with root causes largely due to inadequate settings in rollback segments or overextended undo tablespaces. Recommended solutions entail adjusting parameters like MAXEXTENTS, assessing SQL queries for efficiency, and configuring space parameters for rollback segments appropriately. SAP also advises using Automatic Undo Management for version >= 9i, which relies on adjusting the UNDO_RETENTION parameter effectively to prevent errors like ORA-01555. Additionally, recommendations for redoing rollback segments are provided, highlighting optimal configurations to ensure consistent read operations and avoid database failures.
Key words :
create tablespace psaprollbig datafile '/oracle/<sid>/sapdata<#>/rollbig_1/rollbig, <new_next> minextents <new_minextents> maxextents <new_maxextents> optimal <new_optimal>, create rollback segment prs_<num> tablespace psaproll storage, alter rollback segment prs_<num> online, alter rollback segment prs_<num> offline, create rollback segment prs_big tablespace psaprollbig storage, terms ora-1555 ora-1628 ora-1650 ora-01562 reason, data1' size 2000m default storage, drop rollback segment prs_<num>, alter table <table> modify lob
Related Notes :
| 1069366 | USMM ISU_AUDIT rollback segments are not sufficient |
| 1045320 | ORA-30036 despite high number expired/unexpired undo extents |
| 1039060 | Corrupt Blocks when using physical Standby DB |
| 1021454 | Oracle Segment Shrinking may cause LOB corrupt data |
| 983230 | LOB corruption for NOCACHE LOBs in ASSM (ORA-1555/ORA-22924) |
| 900345 | Backward Release of ORACLE 10.2 - Upgrade Information |
| 789390 | Material forecast: Error ORA-01555 for background forecast |
| 766349 | FAQ: Oracle SQL optimization |
| 709950 | Performance Problem in UPDATE_DB_COMP_TABLES |
| 666061 | FAQ: Database objects, segments and extents |
| 662219 | Add. info. on upgrading to SAP Web AS 6.40 ORACLE |
| 600141 | Oracle9i: Automatic UNDO Management |
| 575280 | Add info about upgrade to SAP Web AS 6.20 ORACLE 9.2.0 |
| 500340 | FAQ: LOBS |
| 491598 | Additional info on upgrading to SAP Web AS 6.20 ORACLE 8.1.x |
| 489690 | CC INFO: Copying large production clients |
| 401721 | on upgrading to SAPWeb AS 6.10 ORACLE |
| 383823 | MP38: Restriction according to materials |
| 303461 | Additions to Upgrade to Basis 4.6D Oracle |
| 201874 | Additions for upgrade to 4.6C/4.6C SR1/4.6C SR2 Oracle |
| 185822 | ora-1555 - cause and action |
| 165247 | Notes on creating rollback segments |
| 82634 | PSAPROLL-Which rollback segments created, and how? |
| 67205 | CC-INFO: Copying large and productive clients |
| 60233 | Oracle rollback segments, more information. |
| 16277 | ORA1562 / ORA1628 |
| 12621 | SAPDBA: speeding up a reorganization |
| 3155 | Termination due to tablespace overflow |