General Information
Library Note
Morgan's Library Page Header
Are you
prepared for the release of Oracle Database
18c ... the first autonomous database? We are here at the Library. It is
time for DBAs to stop fighting robots with their fingers and losing ...
time to start using our intelligence and winning.
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'
Sensitivity Values
SENSITIVITY_NORMAL
VARCHAR2(20)
'NORMAL
SENSITIVITY_HIGH
VARCHAR2(20)
'HIGH'
Dependencies
Documented
No
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.0.1
Security Model
Owned by SYS with no privileges granted
Source
{ORACLE_HOME}/rdbms/admin/dbmshmgr.sql
SET (new 12.2)
Sets the specified Hang Manager parameter to the specified value.
dbms_hang_manager.set(
exec dbms_hang_manager.set ('BASE_FILE_SIZE_LIMIT', '250');
