Re: Where does GC grab historical SQL plans from?
From: Wolfgang Breitling <breitliw_at_centrexcc.com>
Date: Tue, 17 May 2011 06:29:11 -0600
Message-Id: <89861F29-A8DF-4193-938C-2508C6EB18DD_at_centrexcc.com>
Do you need the histograms? Why not just not collect them.
Date: Tue, 17 May 2011 06:29:11 -0600
Message-Id: <89861F29-A8DF-4193-938C-2508C6EB18DD_at_centrexcc.com>
Do you need the histograms? Why not just not collect them.
On 2011-05-13, at 9:22 AM, Rich Jesse wrote:
> Because we have histograms, CBO sees this and
> correctly chooses another index for that query. And because we're on 10.1,
> if this should be the first hard parse of that SQL, the "incorrect" index
> sticks for subsequent runs.
-- http://www.freelists.org/webpage/oracle-lReceived on Tue May 17 2011 - 07:29:11 CDT