Oracle CBO changes between 9i and 10g

Any Oracle DBA responsible for managing a Siebel application should read this excellent whitepaper describing changes in the Cost Based Optimizer (CBO) between Oracle 9i and 10g.

The blog written by the engineering group responsible for the optimizer within Oracle is also worth subscribing to.