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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: 10053 trace for sql fired from pl/sql (stored code)

Re: 10053 trace for sql fired from pl/sql (stored code)

From: Radoulov, Dimitre <cichomitiko_at_gmail.com>
Date: 2005-12-22 22:52:25
Message-id: 032a01c60742$008e9ca0$b300a8c0@IBME1D11967173


> It works with 9i.

I tested it on 9.2.0.4 and 9.2.0.7 on Solaris. The execute immediate 'alter session set \ events ''10053 trace name context forever, level 1''' within a plsql block doesn't seem to \ provide the expected information. The same code works with event 10046.

You could try to trace with 10046 to get the sql and the values of the bind variables and \ then trace with 10053 in sqlplus, but in this way you could miss an important session \ environment information (if the application sets some parameters before calling the plsql \ code for example).  

So you can create a logon trigger that executes "alter session set events '10046 ... " for \ that particular user to see the entire application code.

Regards,
Dimitre Radoulov Received on Thu Dec 22 2005 - 22:52:25 CST

Original text of this message

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