Skip to Main Content

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

oracle database performance after server reboot

668822Mar 6 2009 — edited Mar 7 2009
hi masters,

this is not some kind of question, but a discussion. some statements come from our client that after weekly reboot of system, the oracle database performance is low for some time and increase after some time(say 2 days).

i think it is but obvious, because at reboot oracle flushes all cache, and temporary space, so it need to re parse the sql statements and perform some disc I/O's so it might need some time and hence performance will degrade.

but at the same time some people claim that after reboot their database performance is better than their normal performance for some days. it seems controversial that's why i am posting it here.


what might be the reason behind this?? prior can have a valid reason of hard parsing, but what with second case??

any clarification is highly appreciated...

thank you
regadrs
VD
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 4 2009
Added on Mar 6 2009
8 comments
2,615 views