RE: Tracing

and dont do it and try to do an upgrade(which sql_trace=true) , a simple 1 hour upgrade ran like 16 hours, had me stumped for a while, thankfully the upgrade scripts can be run multiple time with no impact :)  
joe
>>> lisa.koivu_at_efairfield.com 07/16/01 12:00PM >>>
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 <FONT face=Arial
color=#0000ff size=2>Data Bored Administrator <FONT face=Arial color=#0000ff size=2>Ft. Lauderdale, FL, USA   -----Original Message----- <FONT
  face=Arial size=1>From:   <FONT face=Arial   size=1>Ramasamy, Baskar [SMTP:Baskar.Ramasamy_at_calanais.com]   Sent:   <FONT face=Arial
  size=1>Monday, July 16, 2001 11:46 AM <FONT face=Arial   size=1>To:     Multiple
  recipients of list ORACLE-L <FONT face=Arial   size=1>Subject:        <FONT
  face=Arial size=1>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----- <FONT
  face=Arial size=2>Sent: 16 July 2001 16:12 <FONT face=Arial   size=2>To: Multiple recipients of list ORACLE-L   On Jul 16, 2001 at 06:45:36AM, Libal, Ivo   wrote: > > Hello <FONT
  face=Arial size=2>> > 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 <FONT face=Arial   size=2>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 <A target=_blank href="http://vbegun.net/">http://vbegun.net/           | creativity. <A target=_blank href="http://vbegun.net/wap/">http://vbegun.net/wap/       |          -- Kirk, "The return of the <FONT face=Arial size=2>me_at_vbegun.net                |          Archons", stardate 3157.4 -- <FONT face=Arial size=2>Please see the official ORACLE-L FAQ: <A target=_blank href="http://www.orafaq.com">http://www.orafaq.com <FONT face=Arial size=2>-- Author: Vladimir Begun   INET: jester_at_whale.sunbay.crimea.ua Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051 <FONT face=Arial size=2>San Diego, California        -- Public Internet access / Mailing Lists <FONT face=Arial size=2>-------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in <FONT face=Arial size=2>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). <FONT face=Arial size=2>-- Please see the official ORACLE-L FAQ: <A target=_blank href="http://www.orafaq.com">http://www.orafaq.com <FONT face=Arial size=2>-- Author: Ramasamy, Baskar   INET: Baskar.Ramasamy_at_calanais.com Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051 <FONT face=Arial size=2>San Diego, California        -- Public Internet access / Mailing Lists <FONT face=Arial size=2>-------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in <FONT face=Arial size=2>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).