Home » RDBMS Server » Performance Tuning » changing plan after restart
changing plan after restart [message #65232] Wed, 23 June 2004 00:57 Go to next message
Kostya
Messages: 4
Registered: March 2002
Junior Member
I've got a problem with changing execution plan after restarting the server (9.2). After the restart the perfomance of the same select increasing dramatically and the plan is changing. The stat info in system tables not lost.  Thanks for help
Re: changing plan after restart [message #65234 is a reply to message #65232] Wed, 23 June 2004 17:41 Go to previous messageGo to next message
IA
Messages: 91
Registered: March 2004
Member
Hi,

Upon restart, you should let your instance warm up first. Most definitely you will experience a difference in performance due to cache not being fully utilized.

Best to compare performance after warm up first.

IA
Re: changing plan after restart [message #65293 is a reply to message #65232] Fri, 23 July 2004 13:06 Go to previous message
Master P
Messages: 6
Registered: July 2004
Junior Member
If your plan is totally different full table scans before and index scan after reboot you may be facing the bind variable peeking problem.

By the way plans change all the time when there are new stats available and a statement gets aged out of the shared pool and re parsed on subsequent execution.
Previous Topic: CPU utilisation
Next Topic: table compress feature of Oracle 9i
Goto Forum:
  


Current Time: Wed Feb 21 17:51:27 CST 2024