Re: Help me solve this cardinality puzzle

Wow,
a good tip Greg. Thank you !

Best Regards. Milen 

-------- Original-Nachricht --------
> Datum: Sun, 20 Apr 2008 20:18:38 -0700
> Von: "Greg Rahn" <greg@xxxxxxxxxxxxxxxxxx>
> An: makulev@xxxxxxx
> CC: ukja.dion@xxxxxxxxx, oracle-l <oracle-l@xxxxxxxxxxxxx>
> Betreff: Re: Help me solve this cardinality puzzle

> Even easier than tracing is and it shows the value peeked:
> select * from
> table(dbms_xplan.display_cursor(<sql_id>,<child#>,'+PEEKED_BINDS'));
> 
> On Sun, Apr 20, 2008 at 1:30 PM, Milen Kulev <makulev@xxxxxxx> wrote:
> > In order to determine whether bind peekig is occuring or not you should
> > trace your session with one of the events 10053, 10132 or 10046.
> 
> 
> -- 
> Regards,
> 
> Greg Rahn
> http://structureddata.org
> --
> http://www.freelists.org/webpage/oracle-l
> 

-- 
GMX startet ShortView.de. Hier findest Du Leute mit Deinen Interessen!
Jetzt dabei sein: http://www.shortview.de/?mc=sv_ext_mf@gmx
--
http://www.freelists.org/webpage/oracle-l

Other related posts: