| 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: set_sql_trace_in_session
On a
similar note, I'm looking for a way to toggle trace system-wide. Changing the
init.ora sql_trace parameter is not an option since it requires recycling the
database.
<SPAN
class=429222123-19112001>
Any
way to turn sql trace on for a few hours and then turn it back
off?
<SPAN
class=429222123-19112001>
<SPAN
class=429222123-19112001>
Steve
Orr
<SPAN
class=429222123-19112001>
<FONT face=Tahoma
size=2>-----Original Message-----From: Hallas John
[mailto:John.Hallas_at_btcellnet.net]Sent: Monday, November 19, 2001
8:36 AMTo: Multiple recipients of list ORACLE-LSubject:
RE: set_sql_trace_in_session
It is in the 8.1.6 documentation I have just looked at
(Oracle8i Supplied PL/SQL Packages Reference <FONT
size=2>Release 2 (8.1.6) A76936-01
However I have a page on my website which shows how to put
various bits of tracing on try <A
href="http://www.hcresources.co.uk"
target=_blank>http://www.hcresources.co.uk for the home page or <A
href="http://www.hcresources.f2s.com/trace.htm"
target=_blank>http://www.hcresources.f2s.com/trace.htm <FONT
size=2>to go direct.
John
-----Original Message----- From: Paul
Baumgartel [<A
href="mailto:treegarden_at_yahoo.com">mailto:treegarden_at_yahoo.com]
Sent: 19 November 2001 15:05 To:
Multiple recipients of list ORACLE-L Subject:
set_sql_trace_in_session
DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION isn't documented in the
8.1.6/7 doc sets. The package (and the
procedure) exists, though even the package spec source
code is wrapped. What gives? Is this package <FONT
size=2>about to be desupported? Is there an alternative way of setting
trace on in another session?
 |
 |