General Information
Library Note
Morgan's Library Page Header
ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling
complimentary technical Workshops on Database Security for the first 30
Oracle Database customers located anywhere in North America, EMEA, LATAM, or
APAC that send an email to
asra_us@oracle.com . Request a Workshop for
your organization today.
Purpose
Provides a method of changing some Hang Manager configuration parameters.
AUTHID
DEFINER
Constants
Name
Data Type
Value
Parameter Names
RESOLUTION_SCOPE
VARCHAR2(40)
'resolution scope'
SENSITIVITY
VARCHAR2(40)
'sensitivty'
BASE_FILE_SIZE_LIMIT
VARCHAR2(40)
'base file size limit'
BASE_FILE_SET_COUNT
VARCHAR2(40)
'base file set count'
LWS_FILE_SIZE_LIMIT
VARCHAR2(40)
'long waiting session file size limit'
LWS_FILE_SET_COUNT
VARCHAR2(40)
'long waiting session file set count'
Resolution Scope Values
RESOLUTION_SCOPE_OFF
VARCHAR2(20)
'OFF'
RESOLUTION_SCOPE_PROCESS
VARCHAR2(20)
'PROCESS'
RESOLUTION_SCOPE_INSTANCE
VARCHAR2(20)
'INSTANCE'
RESOLUTION_SCOPE_NODE
VARCHAR2(20)
'NODE'
Sensitivity Values
SENSITIVITY_NORMAL
VARCHAR2(20)
'NORMAL
SENSITIVITY_HIGH
VARCHAR2(20)
'HIGH'
Dependencies
Documented
Yes: Packages and Types Reference
Exceptions
Error Code
Reason
ORA-32706
Invalid User Input
ORA-32707
Error generated while trying to set the parameter
ORA-32708
Operation is not supported on this instance type
First Available
12.2
Security Model
Owned by SYS with EXECUTE granted to the DBA role
Source
{ORACLE_HOME}/rdbms/admin/dbmshmgr.sql
SET
Sets the specified Hang Manager parameter to the specified value.
dbms_hang_manager.set(
exec dbms_hang_manager.set ('BASE_FILE_SIZE_LIMIT', '250');
