Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> trace sql statements

trace sql statements

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Wed, 4 Jun 2003 12:20:00 +0100
Message-ID: <E2F6A70FE45242488C865C3BC1245DA703BEB37B@lnewton.leeds.lfs.co.uk>


Morning Urs,

try using level 4 or level 8 to show the bind variable values. I'm sorry I can't remember which is correct as I always use level 12 and get binds and waits in the trace as well. Most useful. :o)

Cheers,
Norman.



Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar_at_LFS.co.uk
Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com

-------------------------------------

-----Original Message-----
From: Urs Stotz [mailto:stotz_at_gmx.ch]
Posted At: Wednesday, June 04, 2003 11:27 AM Posted To: server
Conversation: trace sql statements
Subject: Re: trace sql statements

<BIG SNIP>

There is only one problem. Is there a way to see also the values? I meen instead of (:v1), (:v2) and (:v3).

Best regards,
Urs Received on Wed Jun 04 2003 - 06:20:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US