Oracle DBMS_HANG_MANAGER
Version 12.2.0.1

General Information
Library Note Morgan's Library Page Header
"I spent my entire adult life looking out for the well-being, the training, the equipping of the troops for whom I was responsible. I will not be lectured about what our military needs by a five-deferment draft dodger,"
~ Sen. Tammy Duckworth
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
DBMS_HANG_MANAGER_LIB    
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(
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');

Related Topics
HANGDIAG.SQL
ORADEBUG
Packages
What's New In 12cR1
What's New In 12cR2

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2017 Daniel A. Morgan All Rights Reserved