Oracle-L: RE: Bind Variable values

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Thu, 30 May 2002 05:54:01 -0800
Message-ID: <F001.0046F630.20020530055401@fatcity.com>

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