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

You can override the dynamic sampling that parallel query does with a dynamic_sampling (2) hint.

Hope this helps,
Andy

On Thu, 7 Feb 2019 at 15:00, Chinar Aliyev <chinaraliyev_at_gmail.com> wrote:

> 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
>> <https://maps.google.com/?q=27a+Lidget+Hill+%0D%0APudsey+%0D%0AWest+Yorkshire+%0D%0AUnited+Kingdom+%0D%0ALS28+7LG&entry=gmail&source=g>
>> Pudsey
>> <https://maps.google.com/?q=27a+Lidget+Hill+%0D%0APudsey+%0D%0AWest+Yorkshire+%0D%0AUnited+Kingdom+%0D%0ALS28+7LG&entry=gmail&source=g>
>> West Yorkshire
>> <https://maps.google.com/?q=27a+Lidget+Hill+%0D%0APudsey+%0D%0AWest+Yorkshire+%0D%0AUnited+Kingdom+%0D%0ALS28+7LG&entry=gmail&source=g>
>> United Kingdom
>> <https://maps.google.com/?q=27a+Lidget+Hill+%0D%0APudsey+%0D%0AWest+Yorkshire+%0D%0AUnited+Kingdom+%0D%0ALS28+7LG&entry=gmail&source=g>
>> LS28 7LG
>> <https://maps.google.com/?q=27a+Lidget+Hill+%0D%0APudsey+%0D%0AWest+Yorkshire+%0D%0AUnited+Kingdom+%0D%0ALS28+7LG&entry=gmail&source=g>
>>
>> Company Number: 05132767
>> --
>> http://www.freelists.org/webpage/oracle-l
>>
>>
>>

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