Re: Re: Latch free

in version 9.2 , if you have analyze the column for=
histograms ,then sursor_sharing =3D force may generate bad
excution plan . though oracle 9.2 has "Peeking of User-Defined=
Bind Variables " new feature may cause more problems .

if sursor_sharing =3D similar , and has the columns histograms ,=
then there is always hard parse .
do a test ,query the v$sysstat ,the hard parse increment=
and the v$sql_plan has a new one

Best regards

yahoo id: feng_chunpei
A new dba from china

from the mail-----
>On 04/26/2004 11:17:17 AM, syed jaffar hussain wrote:>> We have a third party tool where I can't change the code and I=
know that
>> this application is not using bind variables, I do set>> cursor_sharing=3Dforce.>>What version of the database? Cursor sharing doesn't work really=
well
>before version 9.2. If you are using 8.1.7, that may be the=
problem.
>-- >Mladen Gogala>Oracle DBA>>>>Note:>This message is for the named person's use only. It may contain=
confidential, proprietary or legally privileged information. No=
confidentiality or privilege is waived or lost by any=
mistransmission. If you receive this message in error, please=
immediately delete it and all copies of it from your system,=
destroy any hard copies of it and notify the sender. You must=
not, directly or indirectly, use, disclose, distribute, print,=
or copy any part of this message if you are not the intended=
recipient. Wang Trading LLC and any of its subsidiaries each=
reserve the right to monitor all e-mail communications through=
its networks.
>Any views expressed in this message are those of the individual=
sender, except where the message states otherwise and the sender=
is authorized to state them to be the views of any such entity.
>>----------------------------------------------------------------=

>Please see the official ORACLE-L FAQ: http://www.orafaq.com>----------------------------------------------------------------=