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

Dynamic sampling?

Clemens Bleile | Senior Consultant & Oracle Technology Leader | Oracle Certified Professional DB 11g, 12c | Oracle Certified Expert DB 12c Performance Management and Tuning Phone: +41 32 422 96 00 | Mobile: +41 78 677 51 09 | Fax: +41 32 422 96 15 dbi services, Rue de la Jeunesse 2, CH-2800 Delémont clemens.bleile_at_dbi-services.com
www.dbi-services.com

⇒ dbi services is recruiting Oracle & SQL Server experts ! – Join the team

-----Original Message-----

From: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> On Behalf Of Norman Dunbar Sent: Thursday, February 7, 2019 11:40 AM To: oracle-l_at_freelists.org
Subject: Re: Why does a hard parse access data in the table in the query?

And of course, I should have included the fact that this is Oracle 11.2.0.4 EE 64bit.

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

†Ûiÿü0ÁúÞzX¬¶Ê+ƒün– {ú+iÉ^ Received on Thu Feb 07 2019 - 11:45:31 CET