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_at_structureddata.org>
  > An: makulev_at_gmx.net
  > CC: ukja.dion_at_gmail.com, oracle-l <oracle-l_at_freelists.org>
  > 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_at_gmx.net> 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