DBMS_HANG_MANAGER

79.1 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.

79.2 DBMS_HANG_MANAGER Security Model

DBMS_HANG_MANAGER can only be run as the SYS user.

79.3 DBMS_HANG_MANAGER Constants

The table in this topic lists DBMS_HANG_MANAGER package constants.

Table 79-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

79.4 DBMS_HANG_MANAGER Exceptions

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

Table 79-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

79.5 Summary of DBMS_HANG_MANAGER Subprograms

The DBMS_HANG_MANAGER package includes the SET procedure subprogram.

Table 79-3 DBMS_HANG_MANAGER Package Subprograms

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

79.5.1 SET Procedure

This procedure sets the specified parameters to specified values.

Syntax

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

Parameters

Table 79-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`