Re: DBMS_SYSTEM.SET_EV parameter nm

  • From: "Rakesh Tikku" <rakesh.tikku@xxxxxxxxx>
  • To: ahbaid@xxxxxxx
  • Date: Tue, 29 Jan 2008 21:34:39 -0800

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@xxxxxxx> 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
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
//www.freelists.org/webpage/oracle-l


Other related posts: