Chuck wrote:
> I'm looking at a 9i database's Top sql with both TOAD and OEM Grid
> Control. The grid control shows a different execution plan for the same
> sql than TOAD does? What would cause this? Stats are the same for both
> and have not changed since the the SQL was first loaded into the shared
> pool. No parameters at either instance or session level have changed
> either. Even if one program was recalculating the execution plan and one
> was pulling it from the shared pool, shouldn't they be the same if
> nothing has changed?
>
> TIA
Should they be the same? I would hope so but what version of TOAD and is
it one that Quest has certified against 10gR1?
--
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Wed May 18 2005 - 14:24:41 CDT
