Re: Why does a hard parse access data in the table in the query?
From: Norman Dunbar <oracle_at_dunbar-it.co.uk>
Date: Thu, 7 Feb 2019 14:48:52 +0000
Message-ID: <d248fbc4-c369-a736-c5aa-f26e808ac926_at_dunbar-it.co.uk>
Date: Thu, 7 Feb 2019 14:48:52 +0000
Message-ID: <d248fbc4-c369-a736-c5aa-f26e808ac926_at_dunbar-it.co.uk>
Hi Chinar,
On 07/02/2019 14:25, Chinar Aliyev wrote:
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,
> Hi.
> Is it parallel query? Could you please post execution plan of it here?
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
Received on Thu Feb 07 2019 - 15:48:52 CET