Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Top SQL question
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
-- To reply by email remove "_nospam"Received on Wed May 18 2005 - 13:27:28 CDT