Where does GC grab historical SQL plans from?
From: Rich Jesse <rjoralist2_at_society.servebeer.com>
Date: Thu, 12 May 2011 08:55:43 -0500 (CDT)
Message-ID: <e761f89194d10ed22cafc03008f129ba.squirrel_at_society.servebeer.com>
Howdy,
Date: Thu, 12 May 2011 08:55:43 -0500 (CDT)
Message-ID: <e761f89194d10ed22cafc03008f129ba.squirrel_at_society.servebeer.com>
Howdy,
Having an issue this AM with a query and a very bad explain plan. It's odd that Grid Control's Top Activity can't seem to locate this SQL in history, considering 15+ folks are running it right now. I've had issues in the past where GC gets confused with two different plans in the GUI, so I'd like to query the data directly.
Thoughts on where GC grabs SQL history from? DBA_HIST_SQL_PLAN on the target DB is oddly devoid of this particular SQL.
And yes, we do have Tuning and Diag packs...
TIA!
Rich
-- http://www.freelists.org/webpage/oracle-lReceived on Thu May 12 2011 - 08:55:43 CDT