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
me_at_vbegun.net                |          Archons", stardate 3157.4
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Vladimir Begun
  INET: jester_at_whale.sunbay.crimea.ua

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: ListGuru_at_fatcity.com (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: Baskar.Ramasamy_at_calanais.com

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: ListGuru_at_fatcity.com (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).