Ravi - I haven't yet had a tuning opportunity to use these ideas, which is
why I just copied and pasted the Metalink text. Therefore, my comments will
be rather general. Hopefully some of those with more experience will
respond.
Offhand, it sounds like you either didn't get the event level 4 set.
What command did you use? Tim Gorman offered the specific syntax. Was your
trace file significantly larger?
You mention tkprof. I understand that you can't use tkprof to locate
these details, you must read the trace file yourself. There are a couple of
sites (http://www.hotsos.com) that offer programs that will produce a report
with the wait times.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-----Original Message-----
Sent: Thursday, May 30, 2002 9:28 AM
To: Multiple recipients of list ORACLE-L
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: 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).
