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