Re: Help me solve this cardinality puzzle
From: Greg Rahn <greg_at_structureddata.org>
Date: Sun, 20 Apr 2008 20:18:38 -0700
Message-ID: <a9c093440804202018jf0f5587i125c15fdaeab9d41@mail.gmail.com>
Date: Sun, 20 Apr 2008 20:18:38 -0700
Message-ID: <a9c093440804202018jf0f5587i125c15fdaeab9d41@mail.gmail.com>
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