General Information
Library Note
Morgan's Library Page Header
Coming to OpenWorld 2018? Be sure to visit the TidalScale booth in Moscone South
and learn how to solve performance problems and lower costs with Software Defined Servers. Before you visit the booth, or if you can't
make it this year, check out TidalScale at www.tidalscale.com . Be
sure to click on the Solutions link and look through the Oracle resources.
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');
