Oracle-L: RE: Bind Variable values

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Thu, 30 May 2002 07:53:41 -0800
Message-ID: <F001.0046FA90.20020530075341@fatcity.com>

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.
dwilliams_at_lifetouch.com

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

Received on Thu May 30 2002 - 10:53:41 CDT