79 DBMS_HANG_MANAGER

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

This chapter contains the following topics:

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