Re: Why does a hard parse access data in the table in the query?
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Mon, 18 Feb 2019 14:37:51 -0500
Message-ID: <4c762b14-2320-a437-7632-28a061a9c836_at_gmail.com>
Date: Mon, 18 Feb 2019 14:37:51 -0500
Message-ID: <4c762b14-2320-a437-7632-28a061a9c836_at_gmail.com>
Yes, and there was a nasty bug with the early versions of 12cR1 which caused system to hang on library latch when dynamic sampling was set to 11. Those bugs can be tricky.....
On 2/18/19 11:23 AM, Jared Still wrote:
> I've seen dynamic sampling consume up to 4 hrs "sampling" daga,
> 11.2.0.3 I believe
-- Mladen Gogala Database Consultant Tel: (347) 321-1217 -- http://www.freelists.org/webpage/oracle-lReceived on Mon Feb 18 2019 - 20:37:51 CET