Database Reference
In-Depth Information
SQL_TRACE SQL_TRACE_WAITS SQL_TRACE_BINDS
---------- --------------- ----------------
ENABLED TRUE FALSE
SQL> EXECUTE sys.dbms_system.read_ev(10046,:lev)
PL/SQL procedure successfully completed.
LEV
----------
8
SET_INT_PARAM_IN_SESSION Procedure
This procedure sets an integer parameter in a foreign database session.
Syntax
DBMS_SYSTEM.SET_INT_PARAM_IN_SESSION(
sid IN NUMBER,
serial# IN NUMBER,
parnam IN VARCHAR2,
intval IN BINARY_INTEGER);
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
intval
Integer value to assign to a parameter
Usage Notes
No exception is raised when an incorrect
SID
or
SERIAL#
are passed.
Examples
The following example shows how to increase the setting of the parameter
SORT_AREA_SIZE
in a
session, e.g., when sorts are slow due to an insufficient default value of the parameter
SORT_
AREA_SIZE.
3
First, start a session and retrieve the current setting of
SORT_AREA_SIZE
by calling
the package
DBMS_UTILITY
.
4
Under most circumstances
SORT_AREA_SIZE
and other
*_AREA_SIZE
parameters should no longer be
used in favor of
PGA_AGGREGATE_TARGET. SORT_AREA_SIZE
cannot be modified with
ALTER SYSTEM
.
3.
Retrieval of parameter settings with
DBMS_UTILITY
works in any session, whereas access to
V$PARAMETER
requires the role
SELECT_CATALOG_ROLE
or other suitable privilege.
4.