Oracle DBMS_HANG_MANAGER
Version 19.3

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
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 18c
What's New In 19c

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
  DBSecWorx