Don't do this blindly. Turning sql_trace = TRUE on for the entire database will decrease performance. And it goes without saying do NOT do this in production! Session level tracing is more appropriate.
Lisa Koivu
Data Bored Administrator
Ft. Lauderdale, FL, USA
-----Original Message-----
From: Ramasamy, Baskar [SMTP:[EMAIL PROTECTED]]
Sent: Monday, July 16, 2001 11:46 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Tracing
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).
