Re: trace sql statements

From: Urs Stotz <stotz_at_gmx.ch>
Date: 4 Jun 2003 10:26:37 GMT
Message-ID: <bbkhgt$ai3u9$1@ID-6697.news.dfncis.de>

Hello Sybrand

Sybrand Bakker wrote:
> On 24 May 2003 08:19:37 GMT, Urs Stotz <stotz_at_gmx.ch> wrote:
>

>> Is it possible each sql statement to trace of an other oracle session?
>> [...]

>
> refer to dbms_system.set_sql_trace_in_session(sid, serial#)
>
> Must be sys to run this
>
> or find the os processid
> and in sqlplus connected as sys issue
> oradebug setospid <pid you found>
> oradebug event 10046 trace name context forever, level 1
>
> or use the dbms_system.set_ev procedure.
> [...]

Thank you for your answer!

I have chose the first one methode.
I have found now this in ORA00382.TRC:
...

---

PARSING IN CURSOR #1 len=224 dep=0 uid=58 oct=3 lid=58

   tim=103975509 hv=4217551702 ad='1dc87930' SELECT BPANALYSES.BPANA,BPANALYSES.BPANANAME,BPANALYSES.BPANAIK    FROM SWCSCDAT.BPANALYSES

      WHERE NOT (BPANALYSES.BPANAIK = (:v1  ))  
         AND (BPANALYSES.CREUSR = (:v2  ) 
         OR BPANALYSES.BPAACCESS = (:v3  )) ORDER BY BPANALYSES.BPANA

END OF STMT
PARSE #1:c=0,e=0,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=0,tim=103975509 EXEC #1:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=103975509

FETCH #1:c=0,e=0,p=0,cr=2,cu=0,mis=0,r=1,dep=0,og=4,tim=103975509
FETCH #1:c=0,e=0,p=0,cr=2,cu=0,mis=0,r=8,dep=0,og=4,tim=103975509
=====================

...

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 - 05:26:37 CDT