To see bind variables values you should look at original trace file, not the result of tkprof parsing.
Igor Neyman, OCP DBA [EMAIL PROTECTED] ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, May 30, 2002 10:28 AM > Hi Dennis, > > Thanks for the answer, I just put event leve4, I could > not get the bind variables values, rather gave me > :b1,:b2 > How do I get those values? > And another thing is > in tkprof values can please explain me about the > query and current rows and cpu and elapsed times? > > my understanding is:query is in consistent mode i.e > rollback is that right? if that is the case if there > are not active entries in rollback segments, query > should give zero right? > and current is blocks in current state? am i right? > > Thank you so much for the clarification. > > Thanks you > Ravi > > > --- DENNIS WILLIAMS <[EMAIL PROTECTED]> wrote: > > Ravi - According to Metalink Note:171647.1, > > > > There are four levels available when setting up > > trace with Event 10046 - > > > > � Level 1 is the default. This level traces > > all activities until the > > trace session is stopped. > > > > � Level 4 provides level 1 tracing and > > displays the entered value > > for all bind variables. Bind variables are the > > values that the user enters. > > The code displays these bind variables as: b1, etc. > > When level 4 is > > activated, the substituted value for the bind > > variable is displayed in the > > trace file. > > > > � Level 8 provides level 1 tracing and > > displays a list of all > > database wait events. Database wait events list the > > reasons if the elapsed > > time is greater than the CPU time in the tkprof > > report. > > > > � Level 12 provides level 1 tracing in > > addition to both bind > > variable substitution and database wait events. > > > > All trace modes will include timed statistics > > information in the trace file. > > > > Be warned that the increasing levels cause > > increasing trace file sizes. > > > > Dennis Williams > > DBA > > Lifetouch, Inc. > > [EMAIL PROTECTED] > > > > > > -----Original Message----- > > Sent: Thursday, May 30, 2002 6:53 AM > > To: Multiple recipients of list ORACLE-L > > > > > > Hi All, > > > > I want to get the individual sql_trace from my > > applicaion as they use loads of bind variables, how > > to > > get those values so that I can run explain plan and > > see them individually? for examploe like event > > 10046? > > > > Thanks for your help. > > Ravi. > > > > > > > > __________________________________________________ > > Do You Yahoo!? > > Everything you'll ever need on one web page > > from News and Sport to Email and Music Charts > > http://uk.my.yahoo.com > > -- > > Please see the official ORACLE-L FAQ: > > http://www.orafaq.com > > -- > > Author: =?iso-8859-1?q?Nalla=20Ravi?= > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services -- (858) 538-5051 FAX: > > (858) 538-5051 > > San Diego, California -- Public Internet > > access / Mailing Lists > > > -------------------------------------------------------------------- > > To REMOVE yourself from this mailing list, send an > > E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of > > 'ListGuru') and in > > the message BODY, include a line containing: UNSUB > > ORACLE-L > > (or the name of mailing list you want to be removed > > from). You may > > also send the HELP command for other information > > (like subscribing). > > -- > > Please see the official ORACLE-L FAQ: > > http://www.orafaq.com > > -- > > Author: DENNIS WILLIAMS > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services -- (858) 538-5051 FAX: > > (858) 538-5051 > > San Diego, California -- Public Internet > > access / Mailing Lists > > > -------------------------------------------------------------------- > > To REMOVE yourself from this mailing list, send an > > E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of > > 'ListGuru') and in > > the message BODY, include a line containing: UNSUB > > ORACLE-L > > (or the name of mailing list you want to be removed > > from). You may > > also send the HELP command for other information > > (like subscribing). > > __________________________________________________ > Do You Yahoo!? > Everything you'll ever need on one web page > from News and Sport to Email and Music Charts > http://uk.my.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: =?iso-8859-1?q?Nalla=20Ravi?= > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
