Chuck wrote:
> DA Morgan wrote:
>
>>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?
>
>
> The database is 9.2.0.5. I'm using a 10g OEM to look at the top sql (as
> well as a 9i OEM).
>
> Toad version is 8.0.0.47 which I believe is certified for all releases
> of Oracle up to 10g.
Then I have no explanation for you other than the possibility that they
are using different data dictionary objects from which to formulate
their answer ... and one of them, hopefully not both of them, is wrong.
--
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Wed May 18 2005 - 17:34:36 CDT
