Re: Why does a hard parse access data in the table in the query?
Date: Thu, 7 Feb 2019 18:59:49 +0400
Message-ID: <CAEfe=X998JuGchh+nBuCu_hyGU4SJCqbT=R09bFXrvMtJekzqw_at_mail.gmail.com>
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.
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-lReceived on Thu Feb 07 2019 - 15:59:49 CET