SQL Performance (MOSC)

MOSC Banner

Bind variables missing in TKPROF output

edited May 23, 2013 10:56PM in SQL Performance (MOSC) 4 commentsAnswered
Hi,

I need to trace some part of an application where SQL statements using bind variables are widely used.

I used DBMS_MONITOR.SESSION_TRACE_ENABLE with waits and binds set to TRUE to start the trace (from SYS, in another session).

I got the bind variable values in the raw *.trc file, but not in the TKPROF output.

Is it the way TKPROF works, or is there some (unpublished) parameter to TKPROF to make it process the bind variables too?

Thanks for your hints.

Pavel

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center