General Information
Library Note
Morgan's Library Page Header
Which has the higher priority in your organization: Deploying a new database or securing the ones you already have?
Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx .
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(
pname IN VARCHAR2,
pvalue IN VARCHAR2);
-- Additional parameters not defined as constants (above) specify BASE_FILE_SET_COUNT (default 5), BASE_FILE_SIZE_LIMIT (default 100MB), LWS_FILE_SET_COUNT (default 5), LWS_FILE_SIZE_LIMIT (default 100MB), RESOLUTION_SCOPE, and SENSITIVITY.
exec dbms_hang_manager.set ('BASE_FILE_SIZE_LIMIT', '250');