Re: Same Query, same database, same application, new plan from one environment but not from another
From: Rumpi Gravenstein <rgravens_at_gmail.com>
Date: Wed, 27 Aug 2008 22:05:41 -0400
Message-ID: <9c9b9dc90808271905x32d2230fs18f7a03a9a7ef13c@mail.gmail.com>
Date: Wed, 27 Aug 2008 22:05:41 -0400
Message-ID: <9c9b9dc90808271905x32d2230fs18f7a03a9a7ef13c@mail.gmail.com>
<snip>
10g stores previous version of stats for 30 days by default, you can
revert stats to see if the better performing plans return and if so
you can compare the different versions of the stats and plans to
identify the culprit and correct it.
</snip>
The queries from the two environments are run within a few minutes of each other, sometimes the Toad version first and sometimes the Access version. Each run uses the same, single bind value. Given that I can't see how the problem can be related to differences in statistics.
I'll check meta-link for odbc slow-down bugs.
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Aug 27 2008 - 21:05:41 CDT