RE: Value of bind variables in tkprof

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Wed, 31 Oct 2001 15:45:27 -0800
Message-ID: <F001.003B9EEE.20011031155519@fatcity.com>

Mike - Haven't used this, so I will be interested in how you come out. If you set trace level to 4 or 12, as in
alter system set timed_statistics = true alter session set events '10046 trace name context forever, level 4'

Then the trace file that is produced should have your bind values. I'm not sure whether you can see them through tkprof or if you have to just directly view the trace file.
 Let me know how you come out.
Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Wednesday, October 31, 2001 5:20 PM To: Multiple recipients of list ORACLE-L

Hello,

I am trying to debug the sql of an app that uses oracle as the back end. In order to see what the app is doing I did the following:

1. had the user log on the the application
2. Started a trace for the users session
3. Had the user go through a normal work flow (it's an order entry app)
4. After the user finished I turned the trace off
5. Used tkprof to extract the sql statements from the users session

There are no problems with any of the above steps.

When I look at the file I see something similar to the following:

select col1,col2,col3,col4,col5
from table1
where col3 = :1
and col5 = :2 ;

Is there any way to see what the actual values for ':1 and :2' are?

Thanks.

MIke

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Mike Guerrero
  INET: mguerrero_at_tachyon.net

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 Wed Oct 31 2001 - 17:45:27 CST