General Information
Library Note
Morgan's Library Page Header
For how many years have you been working
with physical servers that are starving your database of the memory
necessary to deploy important new performance features such as the Result
Cache, Memoptimize Pool, In-Memory Aggregation, In-Memory Column Store, and
Full Database Caching? Too long? Contact me to learn how to improve all
queries ... not just some queries.
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
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 EXECUTE granted to the DBA role
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');
