Database Reference
In-Depth Information
SET_BOOL_PARAM_IN_SESSION Procedure
This procedure sets a boolean parameter in a foreign session.
Syntax
DBMS_SYSTEM.SET_BOOL_PARAM_IN_SESSION(
sid IN NUMBER,
serial# IN NUMBER,
parnam IN VARCHAR2,
bval IN BOOLEAN);
Parameters
Parameter
Description
sid
Session identifier; corresponds to
V$SESSION.SID
serial#
Session serial number; corresponds to
V$SESSION.SERIAL#
parnam
Parameter name; corresponds to
V$PARAMETER.NAME
bval
Boolean value, i.e.,
TRUE
or
FALSE
Usage Notes
No exception is raised when an incorrect
SID
or
SERIAL#
are passed.
Examples
Setting the boolean parameter
TIMED_STATISTICS
to
TRUE
in a session with
SID=12
and
SERIAL#=16
is accomplished as follows:
SQL> EXEC dbms_system.set_bool_param_in_session(12, 16, 'timed_statistics', TRUE);
SET_EV Procedure
This procedure sets a numeric event in a session or generates a dump of information contained
in the SGA or PGA by specifying the name of the dump (i.e.,
SYSTEMSTATE
dump).
5
It is commonly
used to enable tracing of SQL statements, wait events, and binds in a session that exhibits
performance problems and is foreign to the caller's session. Note that tracing wait events
(event 10046 at levels 8 and 12) and/or binds is highly recommended. Use of
DBMS_SYSTEM
.
SET_
SQL_TRACE_IN_SESSION
is discouraged, since it enables SQL trace at level 1, i.e., without bind
variables and wait events.
A
SYSTEMSTATE
dump reveals the current state of an instance and may be used by Oracle Support to
diagnose hanging issues.
5.