Oracle DBMS_HANG_MANAGER
Version 12.2.0.1

General Information
Library Note Morgan's Library Page Header
The Library is currently in the process of being upgraded from Oracle Database Version 12.1.0.2 to 12.2.0.1. Demos are being upgraded to reflect the new Container paradigm as well as EBR (Edition Based Redefinition) and may contain references to CDBs, PDBs, and other objects you may not be familiar with such as CDB_OBJECTS_AE: Welcome to 12c.

Also important ... there are rumors on the web about SPARC and Solaris being discontinued. Welcome to the age of fake news. There is absolutely not a byte of truth to these irresponsible rumors.
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