Re: Why does a hard parse access data in the table in the query?

From: Mladen Gogala <gogala.mladen@xxxxxxxxx>
To: oracle-l@xxxxxxxxxxxxx
Date: Mon, 18 Feb 2019 14:37:51 -0500

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

--
//www.freelists.org/webpage/oracle-l

References:
- Why does a hard parse access data in the table in the query?
  - From: Norman Dunbar
- Re: Why does a hard parse access data in the table in the query?
  - From: Norman Dunbar
- Re: Why does a hard parse access data in the table in the query?
  - From: Jared Still

Other related posts:

» Why does a hard parse access data in the table in the query?- Norman Dunbar
» RE: Why does a hard parse access data in the table in the query?- Noveljic Nenad
» Re: Why does a hard parse access data in the table in the query?- Radoulov, Dimitre
» Re: Why does a hard parse access data in the table in the query?- Norman Dunbar
» RE: Why does a hard parse access data in the table in the query?- Clemens Bleile
» Re: Why does a hard parse access data in the table in the query?- Mladen Gogala
» Re: Why does a hard parse access data in the table in the query?- Norman Dunbar
» Re: Why does a hard parse access data in the table in the query?- Stefan Koehler
» Re: Why does a hard parse access data in the table in the query?- Chinar Aliyev
» Re: Why does a hard parse access data in the table in the query?- Norman Dunbar
» Re: Why does a hard parse access data in the table in the query?- Norman Dunbar
» Re: Why does a hard parse access data in the table in the query?- Chinar Aliyev
» Re: Why does a hard parse access data in the table in the query?- Andy Sayer
» Re: Why does a hard parse access data in the table in the query?- Mladen Gogala
» Re: Why does a hard parse access data in the table in the query?- Powell, Mark
» Re: Why does a hard parse access data in the table in the query?- Mladen Gogala
» Re: Why does a hard parse access data in the table in the query?- Jared Still
» Re: Why does a hard parse access data in the table in the query? - Mladen Gogala
» RE: Why does a hard parse access data in the table in the query?- Mark W. Farnham