Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Fwd: cloned db puzzle
Yes, we have analyze job scheduled and all stats are up to date.
The query plan didn't change, we know that for sure.
On Thu, 03 Feb 2005 16:35:47 +1100, Mark Burgess
<mburgess_nz_at_yahoo.co.nz> wrote:
> Hi Richard,
>
> did you re-analyse after the clone? It sounds like a change in query
> plan has occurred somewhere along the way..possibly from the stats being
> refreshed..
>
> Regards,
>
> Mark
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Feb 03 2005 - 00:49:34 CST