Oracle DBMS_HANG_MANAGER
Version 19.3

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
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 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(
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
Built-in Functions
Built-in Packages
HANGDIAG.SQL
ORADEBUG
What's New In 18cR3
What's New In 19cR3

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-2019 Daniel A. Morgan All Rights Reserved