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

Hi,
Sorry I did not read his reply.
Yes, it may be reaped with it even in 11g. Also, I think you can extract the recusive/sampling sql if possible. Try top_level_sql_id and sql _id columns of dba_hist_active_sess_history view.

To add more, if the parallel SQL containes ORDER BY clause, in this case database does implicit sampling which may suitable for your case.

On Thu, Feb 7, 2019, 18:49 Norman Dunbar <oracle_at_dunbar-it.co.uk wrote:

> Hi Chinar,
>
> On 07/02/2019 14:25, Chinar Aliyev wrote:
> > Hi.
> > Is it parallel query? Could you please post execution plan of it here?
>
> Yes, parallel is involved as the tables are very large. Sorry, I can't
> post an execution plan here though. :o(
>
> Stefan has pointed me in the direction of a possible bug/feature though,
> which might account for the disc accessing and dynamic sampling.
>
>
> Cheers,
> Norm.
>
> --
> Norman Dunbar
> Dunbar IT Consultants Ltd
>
> Registered address:
> 27a Lidget Hill
> Pudsey
> West Yorkshire
> United Kingdom
> LS28 7LG
>
> Company Number: 05132767
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

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