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: Wolfgang Breitling <breitliw_at_centrexcc.com>
Date: 2005-12-22 21:14:20
Message-id: 43AB091C.2050606@centrexcc.com


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
http://www.centrexcc.com
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Dec 22 2005 - 21:14:20 CST

Original text of this message

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