Re: Help me solve this cardinality puzzle

  • From: "Greg Rahn" <greg@xxxxxxxxxxxxxxxxxx>
  • To: makulev@xxxxxxx
  • Date: Sun, 20 Apr 2008 20:18:38 -0700

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
--
//www.freelists.org/webpage/oracle-l


Other related posts: