Best option would be turn on the sql_trace and timed_statistice parameter
in init.ora and re-start the database.
But makes ure you have enought space to write trc files in OS
Baskar
-----Original Message-----
Sent: 16 July 2001 16:12
To: Multiple recipients of list ORACLE-L
On Jul 16, 2001 at 06:45:36AM, Libal, Ivo wrote:
> > Hello
> > I would like to start tracing for different session than my one. How it
is
> > possible in 8.1.7 EE? I want to start tracing for different sessions
with
> > different levels (not necessary diff. levels). I found that it should be
> > possible with dbms_support package, but i didnt find this package and I
> > also didnt find creation script in my rdbms/admin directory (it should
be
> > dbmssupp.sql).
> > Please help me where I can find it or how to do it.
> > Ivo Libal
dbms_system.set_ev(sid, serial, event, level, NULL);
--
Vladimir Begun | Without freedom of choice there is no
http://vbegun.net/ | creativity.
http://vbegun.net/wap/ | -- Kirk, "The return of the
[EMAIL PROTECTED] | Archons", stardate 3157.4
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Vladimir Begun
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ramasamy, Baskar
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).