using dbms_system.set_ev instead of alter session

From: Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
Date: Tue, 23 Jan 2001 14:31:03 -0800
Message-Id: <10750.127330@fatcity.com>

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01C0858C.2B319800
Content-Type: text/plain;

charset="iso-8859-1"

The Oracle FAQ mentioned at the end of the list e-mails has the following hint for tracing:

# Trace SQL statements and show bind variables in trace output event = "10046 trace name context forever, level 12"

I want to do this for a session started by a program. So instead of alter session I need to use dbms_system.set_ev However, I don't see how I can specify a length of time (in this case "forever") to that procedure. It looks like the syntax should be (from inside SQL*Plus) execute sys.dbms_system.set_ev (sid, serial#, 10046, 15, 'context') ; where 10046 is the event for "enable SQL statement timing"

How do I indicate to set_ev the length of time for which tracing for that event should be enabled. If the default is forever, then I would guess that the only way to terminate the tracing is to end the session?

any ignorant comments made are the sole responsibility of J. R. Kilchoer and should not reflect adversely upon my employer.

Jacques R. Kilchoer
(949) 754-8816
Quest Software, Inc.
8001 Irvine Center Drive
Irvine, California 92618
U.S.A.
http://www.quest.com

------_=_NextPart_001_01C0858C.2B319800
Content-Type: text/html;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2652.35">
<TITLE>using dbms_system.set_ev instead of alter session - how to =
indicate length of tracing?</TITLE>
</HEAD>
<BODY>

The Oracle FAQ mentioned at the end of the list =
e-mails has the following hint for tracing:


# Trace SQL statements and show bind variables in =
trace output
 event =3D "10046 trace name context forever, =
level 12"


I want to do this for a session started by a program. =
So instead of alter session I need to use dbms_system.set_ev  = However, I don't see how I can specify a length of time (in this case = "forever") to that procedure.

It looks like the syntax should be (from inside =
SQL*Plus)
 execute sys.dbms_system.set_ev (sid, serial#, 10046, =
15, 'context') ;
 where 10046 is the event for "enable SQL =
statement timing"


How do I indicate to set_ev the length of time for =
which tracing for that event should be enabled. If the default is = forever, then I would guess that the only way to terminate the tracing = is to end the session?

------
 any ignorant comments made are the sole =
responsibility of J. R. Kilchoer and should not reflect adversely upon = my employer.

 
 Jacques R. Kilchoer
 (949) 754-8816
 Quest Software, Inc.
 8001 Irvine Center Drive
 Irvine, California 92618
 U.S.A.
 <A HREF=3D"http://www.quest.com" =
TARGET=3D"_blank">http://www.quest.com</A> Received on Tue Jan 23 2001 - 16:31:03 CST

using dbms_system.set_ev instead of alter session - how to indica