RE: Re: Latch free

From: Jamadagni, Rajendra <Rajendra.Jamadagni_at_espn.com>
Date: Mon, 26 Apr 2004 12:45:34 -0400
Message-ID: <A186CBDC8B1D61438BC50F1A77E91F73075BD4DE@xchgbrsm1.corp.espn.pvt>

It only likes EXACT ...=20

Raj

---

--------=20
Rajendra dot Jamadagni at nospamespn dot com=20 All Views expressed in this email are strictly personal.=20 select standard_disclaimer from company_requirements;=20 QOTD: Any clod can have facts, having an opinion is an art !

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Ravi Kulkarni Sent: Monday, April 26, 2004 12:01 PM
To: oracle-l_at_freelists.org
Subject: RE: Re: Latch free

cursor_sharing =3D similar did not like our use of PIPELINE functions in 9.2.

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of biti_rainy Sent: Monday, April 26, 2004 10:57 AM
To: oracle-l_at_freelists.org
Subject: Re: Re: Latch free

hi,Mladen Gogala

  oracle9.2 ,JDBC always has bugs.

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

if sursor_sharing =3D3D similar , and has the columns histograms ,=3D then there is always hard parse .
do a test ,query the v$sysstat ,the hard parse increment=3D  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=3D
  know that
  >> this application is not using bind variables, I do set=20
  >> cursor_sharing=3D3Dforce.
  >
  >What version of the database? Cursor sharing doesn't work really=3D
  well=20
  >before version 9.2. If you are using 8.1.7, that may be the=3D
  problem.
  >--
  >Mladen Gogala
  >Oracle DBA
  >
  >
  >
  >Note:
  >This message is for the named person's use only. It may contain=3D
  confidential, proprietary or legally privileged information. No=3D confidentiality or privilege is waived or lost by any=3D = mistransmission. If you receive this message in error, please=3D immediately delete it = and all copies of it from your system,=3D destroy any hard copies of it and notify the sender. You must=3D not, directly or indirectly, use, disclose, distribute, print,=3D or copy any part of this message if you are not the intended=3D recipient. Wang Trading LLC and any of its subsidiaries each=3D reserve the right to monitor all e-mail communications through=3D its networks.
  >Any views expressed in this message are those of the individual=3D
  sender, except where the message states otherwise and the sender=3D is authorized to state them to be the views of any such entity.
  >
  >----------------------------------------------------------------=3D
  

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

>To unsubscribe send email to: oracle-l-request_at_freelists.org put=20
>'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
>----------------------------------------------------------------=3D
-
>
>.

=3DA1=3DA1=3DA1=3DA1=3DA1=3DA1=3DA1=3DA1=3DA1=3DA1=3DA1=3DA1=3DA1=3DA1=3D= A1=3DA1

---

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

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


----------------------------------------------------------------
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 - 11:42:49 CDT