Oracle 8i DBMS_SYSTEM parameters - help!

From: Erkka Hakkarainen - Inet.fi <erkka.hakkarainen_at_pp.inet.fi>
Date: Wed, 12 Jun 2002 08:58:00 GMT
Message-ID: <s2EN8.101$Ad.3114@read2.inet.fi>

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 Received on Wed Jun 12 2002 - 03:58:00 CDT