tag:blogger.com,1999:blog-15574215.post113283667040369808..comments2023-03-30T11:32:15.820+03:00Comments on Oracle Today: Be careful about bind peekingYasin Baskanhttp://www.blogger.com/profile/07642821755164831104noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-15574215.post-85273234107566125862007-03-31T21:55:00.000+03:002007-03-31T21:55:00.000+03:00Sergi,When talking about execution plans don't rel...Sergi,<BR/>When talking about execution plans don't relay on explain plain.<BR/><A HREF="http://oracledba.blogspot.com/2007/03/tracing-commands.html" REL="nofollow">Enable event 10046</A> and check its dump trace file.Yossi Nixonhttps://www.blogger.com/profile/13316395735527835803noreply@blogger.comtag:blogger.com,1999:blog-15574215.post-1173476442364409352007-03-09T23:40:00.000+02:002007-03-09T23:40:00.000+02:00hi,I have read your post, it's very interesting.In...hi,<BR/><BR/>I have read your post, it's very interesting.<BR/>In my company we have 2 enviroments, development and production both have the same characteristics, parameters etc...<BR/>One query needs 0 seconds to be executed in the dev instance and 5 seconds in the production instance. The execution plan is equal in both instances. In theory production machine is powerfull than dev machine.<BR/>Do you know what is happening?<BR/>Very strange.<BR/><BR/>Greetings.<BR/>SergiAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-15574215.post-1152095395173041982006-07-05T13:29:00.000+03:002006-07-05T13:29:00.000+03:00If the execution plans are very different, you wou...If the execution plans are very different, you would have to resort to using different versions of c2 for parameters with different statistics - eg list the selected fields in a different order, or choose a different alias for the table.Anonymousnoreply@blogger.com