RE: disable bv peeking at the statement level (hint?)
- From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxxxxx>
- To: <jonathan@xxxxxxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 12 Jan 2006 17:59:59 -0500
Very cool, I didn't know about that one!
--
Mark J. Bobak
Senior Oracle Architect
ProQuest Information & Learning
"There are 10 types of people in the world: Those who understand
binary, and those who don't."
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Jonathan Lewis
Sent: Thursday, January 12, 2006 5:56 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Re: disable bv peeking at the statement level (hint?)
In 10.2 there is an undocumented hint (one of dozens)
opt_param(parameter_name , value)
that could be used to set the _optim_peek_user_binds parameter to false
- but that probably isn't something you should do on production system;
then again, I guess you are already doing that at the system/session
level.
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html
Cost Based Oracle: Fundamentals
http://www.jlcomp.demon.co.uk/appearances.html
Public Appearances - schedule updated 10th Jan 2006
----- Original Message -----
From: "Boris Dali" <boris_dali@xxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
Sent: Thursday, January 12, 2006 3:00 PM
Subject: disable bv peeking at the statement level (hint?)
> ...can be done at the system/session level, but is
> there a way to to do that for a specific statement?
>
> Oracle 9.2.0.6/7 (but would be interesting to know for
> 10g as well)
>
> Thanks,
> Boris Dali.
>
>
>
>
>
>
> __________________________________________________________
> Find your next car at http://autos.yahoo.ca
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
//www.freelists.org/webpage/oracle-l
BEGIN:VCARD
VERSION:2.1
N:Bobak;Mark
FN:Bobak, Mark
ORG:ProQuest Information and Learning;Database Group
TITLE:Software Architect, Sr-TPD
TEL;WORK;VOICE:734.975.6086
ADR;WORK:;ECC4-N01E04;1400 Eisenhower Parkway
LABEL;WORK;ENCODING=QUOTED-PRINTABLE:ECC4-N01E04=0D=0A1400 Eisenhower Parkway
EMAIL;PREF;INTERNET:Mark.Bobak@xxxxxxxxxxxxxxx
REV:20051213T223654Z
END:VCARD
Other related posts:
