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!

DB performance drops after DB bounce

user4566776Apr 3 2010 — edited Apr 6 2010

Hello,

In one of our Production databases the Performance of Jobs suddenly drops after Database restart.

I suspect the SQL execution plan for 1 or few SQL's in the JOB changes after restart.

What all factors can cause an SQL Execution plan to change ?
How do I determine the cause ? [any trace or dumping thru ORADEBUG. will it help ?

Thanks in advance for yur help.

Regards,
Valli

Locked Post

New comments cannot be posted to this locked post.

Locked on May 4 2010

Added on Apr 3 2010

#general-database-discussions, #performance

9 comments

4,052 views