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 <DWILLIAMS_at_LIFETOUCH.COM> 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.
> dwilliams_at_lifetouch.com
>
>
> -----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: vvnrk2001_at_yahoo.co.uk
>
> 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: ListGuru_at_fatcity.com (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: DWILLIAMS_at_LIFETOUCH.COM
>
> 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: ListGuru_at_fatcity.com (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: vvnrk2001_at_yahoo.co.uk
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: ListGuru_at_fatcity.com (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).
Received on Thu May 30 2002 - 09:28:25 CDT