DBMS_BLOCKER_RESOLVER

DBMS_BLOCKER_RESOLVER Overview

The DBMS_BLOCKER_RESOLVER package provides a method of changing some Blocker Resolver configuration parameters.

Note:

The DBMS_HANG_MANAGER package is deprecated in Oracle Database 23ai. Use DBMS_BLOCKER_RESOLVER instead.

The DBMS_HANG_MANAGER package provides a method of changing some configuration parameters and constraints to address session issues. This package is being replaced with DBMS_BLOCKER_RESOLVER. DBMS_HANG_MANAGER can be removed in a future release.

Blocker Resolver is always enabled on all databases, Automatic Storage Management (ASM) disk groups, and single instance systems (when not using Oracle RAC). Delay 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_BLOCKER_RESOLVER package is intended for use by database administrators (DBA) only. It is not intended for use by application developers.

DBMS_BLOCKER_RESOLVER Security Model

DBMS_BLOCKER_RESOLVER can only be run as the SYS user.

DBMS_BLOCKER_RESOLVER Constants

The table in this topic lists DBMS_BLOCKER_RESOLVER package constants.

Table 42-1 DBMS_BLOCKER_RESOLVER 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 Blocker Resolver intervals to their default values. The default value is `NORMAL`.
`SENSITIVITY_HIGH`	`VARCHAR2`	`HIGH`	Sets the various Blocker Resolver intervals to half of their default values

DBMS_BLOCKER_RESOLVER Exceptions

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

Table 42-2 DBMS_BLOCKER_RESOLVER 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_BLOCKER_RESOLVER Subprograms

The DBMS_BLOCKER_RESOLVER package includes the SET procedure subprogram.

Table 42-3 DBMS_BLOCKER_RESOLVER 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_BLOCKER_RESOLVER.SET (
   pname   IN  VARCHAR2,
   pvalue  IN  VARCHAR2);

Parameters

Table 42-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`.