Re: Re: Latch free

From: biti_rainy <biti_rainy_at_itpub.net>
Date: 26 Apr 2004 16:00:13 -0000
Message-Id: <20040426154339.60F1972C971@turing.freelists.org>

hi,Mladen Gogala

  oracle9.2 ,JDBC always has bugs.

  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
>----------------------------------------------------------------=

>To unsubscribe send email to: oracle-l-request_at_freelists.org
>put 'unsubscribe' in the subject line.
>--
>Archives are at http://www.freelists.org/archives/oracle-l/
>FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
>----------------------------------------------------------------=
-
>
>.

=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1

---

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

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Mon Apr 26 2004 - 10:54:35 CDT