Re: Help me solve this cardinality puzzle
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_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-lReceived on Sun Apr 20 2008 - 22:18:38 CDT