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

From: Norman Dunbar <oracle@xxxxxxxxxxxxxxx>
To: oracle-l@xxxxxxxxxxxxx
Date: Thu, 7 Feb 2019 14:46:48 +0000

Hi Stefan,

On 07/02/2019 14:12, Stefan Koehler wrote:

Hello Norman,
any chance that PX is involved or at least costed?

Yes, this database runs almost permanently in parallel mode.

I am talking about behavior described in MOS ID #1102413.1

Interesting, thanks very much, I'll look into this, it might be relevant.

Cheers,
Norm.

--
Norman Dunbar
Dunbar IT Consultants Ltd

Registered address:
27a Lidget Hill
Pudsey
West Yorkshire
United Kingdom
LS28 7LG

Company Number: 05132767
--
//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: Stefan Koehler

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