RE: Value of bind variables in tkprof

Hi,

TKPROF is not designed to format the event 10046 level 4 data. It can only format the trace of event 10046 level 1 (Read: SQL Trace).

If you want to format the higher level trace file you need to use *itprof* (Check www.unal-bilisim.com ) *sparky* Hotsos profiler
(Check www.hotsos.com).

The first one is free and Hotsos is free for their customers.

Best Regards,
K Gopalakrishnan
Bangalore, INDIA
+ (91) 98451 78868

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

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


_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: K Gopalakrishnan
  INET: kaygopal_at_yahoo.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).