Re: Bad plan selected at the beginning of the month for partitioned table
From: Rich J <rjoralist3_at_society.servebeer.com>
Date: Thu, 01 Feb 2018 10:38:05 -0600
Message-ID: <aade1e66305525788573085b780a2655_at_society.servebeer.com>
Date: Thu, 01 Feb 2018 10:38:05 -0600
Message-ID: <aade1e66305525788573085b780a2655_at_society.servebeer.com>
On 2018/02/01 09:29, Jay.Miller_at_tdameritrade.com wrote:
Are you specifying (the logically confusing) "no_invalidate=>true" when collecting stats? I would think that could account for what you're seeing.
Smarter people than I (and ones with better memory, too) would also know if an invalidation from stats causes a new child cursor that you would be able to see, depending on DB version.
Just a thought...
Rich
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Feb 01 2018 - 17:38:05 CET