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).
