RE: Tracing

Hello list,

Following link explains all issues on sql/event10046 traces:

http://www.unal-bilisim.com/products/itrprof/itrprof_user_manual.html#sql_trace

16/7/01 07:10:35, "JOE TESTA" <JTESTA_at_longaberger.com> wrote:

>
>
>
> 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
> Data Bored Administrator
> Ft. Lauderdale, FL, USA
>
>
> -----Original Message-----
> From: Ramasamy, Baskar [SMTP:Baskar.Ramasamy_at_calanais.com]
> 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
> 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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Danisment Gazi Unal (Unal Bilisim)
  INET: danisment.unal_at_unal-bilisim.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).