| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Tracing
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-LSubject: 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).Received on Mon Jul 16 2001 - 10:03:01 CDT
 |
 |