vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| 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" |