Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: xplan row source 9i

RE: xplan row source 9i

From: Gogala, Mladen <MGogala_at_allegientsystems.com>
Date: Fri, 10 Dec 2004 12:15:52 -0500
Message-ID: <D42C14B2E3F2B74DB41D5B6B2E2B992F01931F82@pegasus.lawaudit.com>


Barbara, there is an undocumented parameter that prevents the optimizer from being a peeping Tom. The parameter is: _optim_peek_user_binds=FALSE
--

Mladen Gogala
Ext. 121

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

From: Barbara Baker [mailto:barb.baker_at_gmail.com] Sent: Friday, December 10, 2004 11:45 AM To: Oracle-L_at_freelists.org
Subject: xplan row source 9i
  Did
version 9i do some "bind variable peeking" that 8i did not do? If so, is there a hint to turn it off?

--

http://www.freelists.org/webpage/oracle-l Received on Fri Dec 10 2004 - 11:17:05 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US