Fwd: cloned db puzzle
- From: Richard Ji <richard.c.ji@xxxxxxxxx>
- To: "Oracle L (E-mail)" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 3 Feb 2005 00:46:11 -0500
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@xxxxxxxxxxx> 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
