Re: Oracle 8i DBMS_SYSTEM parameters - help!

I think you may have dbmssupp.sql in your release, which will create the package
dbms_support, which can do this 'officially'.

Otherwise, the parameters are:

    dbms_system.set_ev(

        sid, serial, event, level, name
    );

So you will need to do:

    execute dbms_system.set_ev(

        12, 42774, 10046, 8, null
    )
;

--
Jonathan Lewis
http://www.jlcomp.demon.co.uk

Next Seminars
        UK            June / July
        Australia      July / August
http://www.jlcomp.demon.co.uk/seminar.html

Erkka Hakkarainen - Inet.fi wrote in message ...


>Help: anyone know of  a Oracle 8i - Supplied PL/SQL Package called

>DBMS_SYSTEM, it seems to be missing from the supplied packages

>documentation.

>

>I would need to turn on tracing for a application session with timed

events.


>

>I know thay the syntax for turning on the tracing is:

>

>select username, sid, serial#

>

>from v$session

>

>where username is not null;

>

>

>

>USERNAME                             SID   SERIAL#

>

>------------------------------ --------- ---------

>

>EVS                                   12     42774

>

>

>

>execute sys.dbms_system.set_sql_trace_in_session(12,42774,TRUE);

>

>

>

>For session EVS, but how to give more parameters in order to turn on

tracing


>of timed events...?

>

>

>

>All help would be really APPRECIATED - Thanks in Advance - Eric

>

>

>--

>_________________________________

>EVS Audio

>Erkka Hakkarainen

>Leinikintie 2 B 18

>FIN-45610 KORIA

>tel: 050-5531405

>email: erkka.hakkarainen_at_pp.inet.fi

>

>