DBMS_HANG_MANAGER

The DBMS_HANG_MANAGER package provides a method of changing some Hang Manager configuration parameters.

This chapter contains the following topics:

• DBMS_HANG_MANAGER Overview

• DBMS_HANG_MANAGER Security Model

• DBMS_HANG_MANAGER Constants

• DBMS_HANG_MANAGER Exceptions

• Summary of DBMS_HANG_MANAGER Subprograms

DBMS_HANG_MANAGER Overview

The DBMS_HANG_MANAGER package provides a method of changing some Hang Manager configuration parameters.

Hang Manager is always enabled on all databases, Automatic Storage Management (ASM) disk groups, and single instance systems (when not using Oracle RAC). Hang resolution is enabled on all instances by default except for single instance systems (when not using Oracle RAC) where it is disabled and cannot be enabled at this time.

Note: The DBMS_HANG_MANAGER package is intended for use by database administrators (DBA) only. It is not intended for use by application developers.

.infoboxnote}

DBMS_HANG_MANAGER Security Model

DBMS_HANG_MANAGER can only be run as the SYS user.

DBMS_HANG_MANAGER Constants

The table in this topic lists DBMS_HANG_MANAGER package constants.

Table 1 DBMS_HANG_MANAGER Constants

Name	Type	Value	Description
RESOLUTION_SCOPE	VARCHAR2	resolution scope	Resolution scope parameter name
SENSITIVITY	VARCHAR2	sensitivity	Sensitivity parameter name
BASE_FILE_SIZE_LIMIT	VARCHAR2	base file size limit	Base file size limit parameter name. The default value of this parameter is 100 MB.
BASE_FILE_SET_COUNT	VARCHAR2	base file set count	Base file set count parameter name. The default value is 5 trace files in the circular trace file set.
LWS_FILE_SIZE_LIMIT	VARCHAR2	long waiting session file size limit	Long waiting session file size limit parameter name. The default value of this parameter is 100 MB.
LWS_FILE_SET_COUNT	VARCHAR2	long waiting session set count	Long waiting session set count parameter name. The default value is 5 trace files in the circular trace file set.
RESOLUTION_SCOPE_PROCESS	VARCHAR2	PROCESS	Enables only session and/or process termination
RESOLUTION_SCOPE_INSTANCE	VARCHAR2	INSTANCE	Enables session, process, and instance termination. The latter is used in specific scenarios. The default value is INSTANCE.
SENSITIVITY_NORMAL	VARCHAR2	NORMAL	Sets various Hang Manager intervals to their default values. The default value is NORMAL.
SENSITIVITY_HIGH	VARCHAR2	HIGH	Sets the various Hang Manager intervals to half of their default values

DBMS_HANG_MANAGER Exceptions

The table in this topic lists the exceptions raised by the DBMS_HANG_MANAGER package.

Table 2 DBMS_HANG_MANAGER Package Exceptions

Exception	Error Code	Description
ERRNUM_INPUT_ERROR	-32706	Invalid user input
ERRNUM_INTERNAL_ERROR	-32707	Database experienced an error setting a parameter
ERRNUM_UNSUPPORTED_ERROR	-32708	Operation is not supported on this instance type

Summary of DBMS_HANG_MANAGER Subprograms

The DBMS_HANG_MANAGER package includes the SET procedure subprogram.

Table 3 DBMS_HANG_MANAGER Package Subprograms

Subprogram	Description
SET Procedure	Sets the specified parameter to the specified value

SET Procedure

This procedure sets the specified parameters to specified values.

Syntax

DBMS_HANG_MANAGER.SET (
   pname   IN  VARCHAR2,
   pvalue  IN  VARCHAR2);

Parameters

Table 4 SET Procedure Parameters

Parameter	Description
pname	Contains the parameter name that needs to be modified
pvalue	Contains the new value for the parameter name specified in pname