Home » RDBMS Server » Server Administration » Problems with Oracle 8.1.7.3.0 optimizer (Sun Solaris)
Problems with Oracle 8.1.7.3.0 optimizer (Sun Solaris) [message #54777] Wed, 04 December 2002 08:00
Kishore
Messages: 45
Registered: September 2000
Member
Are there any issues related to optimizer/analyze? Optimizer making wrong plans after analyze, in some cases! Query execution is good with old statistics and when analyzed the execution is very poor. This is clearly observed with one or more queries.

Report message to a moderator

Previous Topic: Fail to startup Database.... urgent!!!
Next Topic: Killing a session in KILLED status
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Dec 27 18:31:01 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.