Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Top SQL question

Re: Top SQL question

From: Chuck <skilover_nospam_at_softhome.net>
Date: Wed, 18 May 2005 15:43:22 -0400
Message-ID: <1116444809.575f26c8928585c8e0127d4b83930abb@bubbanews>


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.

-- 
To reply by email remove "_nospam"
Received on Wed May 18 2005 - 14:43:22 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US