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

  • From: Wolfgang Breitling <breitliw@xxxxxxxxxxxxx>
  • To: boris_dali@xxxxxxxx
  • Date: Thu, 22 Dec 2005 13:14:20 -0700

Boris,

as the other posters already pointed out, you can request the 10053 trace the same way you would a 10046 (aka sql_trace, or Cary trace):

From within the stored procedure using execute immediate 'alter session ...'
From outside the SP, from a different session, you can use dbms_system.set_ev(sid, serial#, event#, level, '');


Both methods work independent of the Oracle release (at least the current mainstay releases 7.3 through 10.2).

Boris Dali wrote:

Any trick that makes it possible to obtain this
somehow?
Thanks,
Boris Dali.



-- Regards

Wolfgang Breitling
Centrex Consulting Corporation
www.centrexcc.com
--
//www.freelists.org/webpage/oracle-l


Other related posts: