RE: Tracing

Mon, 16 Jul 2001 08:16:02 -0700

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


>>> [EMAIL PROTECTED] 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
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).

Reply via email to