Re: DBMS_SYSTEM.SET_EV parameter nm

Hi Ahbaid,

nm is used for setting the Event Name. That is what come after "trace name" keyword in the alter session set events command.

nm = null stands for "context forever".

so if you want to set "alter system set events '1000 trace name errorstack level 1' " for a particular session, you would use

ev = 1000
le = 1
nm = 'ERRORSTACK'

 hth.

Rakesh Tikku
Managing Principal
dbPerf Inc.

On Jan 29, 2008 9:06 PM, Ahbaid Gaffoor <ahbaid_at_att.net> wrote:
> Does anyone know what the "NM" parameter of DBMS_SYSTEM.SET_EV
> actually gets used for?
>
> Typically it gets set to null when the procedure is called, but I'd like
> to know if it has some usefulness that can be harnessed.
>
> thanks
>
> Ahbaid Gaffoor
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l