2018-09-26 08:54:31 UTC
I am having a hard time in debugging the RC for many plan differences
between 2 DBs where the only difference is in system statistics (especially
MREADTIM and CPUSPEED) . All other DB parameters are same.
Bad plans (using NL joins) in PROD. Good plan( Hash joins) in test
I read this article from Franck and one more where he mention an existing
Is there any workaround to getting *pending system statistics *working in
18.104.22.168 in order to check if that will resolve the problem? I do not want
to cause widespread issues by importing system statistics when i know (
per the above blog) that system statistics wont remain pending!
Or would you suggest any other structured approach in order to find the
problem? I am not good at all in reading 10053 trace .