my Siebel sandpit

The final release of Oracle 9i (9.2.0.8) was released last year and the release notes includes details of bugs that may potentially affect Siebel. See Note 358776.1 on Metalink for full details.

• 3279497 - Excessive CPU from INDEX insert into ASSM index segment
• 4288876 - Excessive redo / undo generation from insert/update with ASSM indexes
• 4694312 - Index inserts to ASSM segments can be slow
• 3332598 - OERI 15160 with OPTIMIZER_MODE=FIRST_ROWS_10
• 3857117 - Wrong results due to CBO choosing wrong index
• 4294948 - Cardinality estimation can be wrong first_rows(k) mode
• 4479933 - Index skip scan not considered for > or >= with bind variables
• 4570598 - Cheapest plan may be rejected in FIRST_ROWS
• 4573396 - CBO does not account for chained rows
• 4711525 - Parsing of bitmapped plans can be slow
• 4772145 - Gathering statistics on large indexes is slow
• 4901231 - Index skip scan not used although cheaper
• 4103409 - HPUX: Performance degradation observed in 9206 than in 9204