Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle 11g upgrade issues

user87124Sep 1 2010 — edited Sep 1 2010

Hello :

We recently migrated our database from 9.2.07 (RBO) to 11.2.0.1 (CBO) ( Solaris 10 Sparc 64 bit ). Ever since the migration happened we are experiencing the following issues:

1. Execution plans are very costly. ( Please note that we moved from RBO to CBO )

2. High Gets / Reads

3. High CPU Utilization

4. High waits on 'DB FILE SEQUENTIAL READ'

5. This situation is vitually killing all our applications performance.

I know that oracle 11g explicitly does not support RULE based optimizer , but is there any parameters that can force it go the RBO way.
I would really appreciate your help.

Regards,

BMP

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 29 2010

Added on Sep 1 2010

#general-database-discussions

6 comments

959 views