Re: Production and Test Environment Queries Behaving Differently
From: Sayan Malakshinov <xt.and.r_at_gmail.com>
Date: Mon, 18 Sep 2017 23:56:04 +0300
Message-ID: <CAOVevU5Py949pUyc-tBcrsF76CtFXgG5xCUE1GHVWczrd-OHAw_at_mail.gmail.com>
Date: Mon, 18 Sep 2017 23:56:04 +0300
Message-ID: <CAOVevU5Py949pUyc-tBcrsF76CtFXgG5xCUE1GHVWczrd-OHAw_at_mail.gmail.com>
Hi Ian,
You have different execution plans, so you need to analyze why...
> The test query was also failing until statistics were regenerated for
tables involved.
> This has not worked for the production environment.
Have you compared statistics on prod and test databases?
Though it's much easier to find the root cause if you compare traces 10053
on both environments.
-- Best regards, Sayan Malakshinov Oracle performance tuning engineer Oracle ACE Associate http://orasql.org -- http://www.freelists.org/webpage/oracle-lReceived on Mon Sep 18 2017 - 22:56:04 CEST