DBMS_BLOCKER_RESOLVER

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

This chapter contains the following topics:

• DBMS_BLOCKER_RESOLVER Overview

• DBMS_BLOCKER_RESOLVER Security Model

• DBMS_BLOCKER_RESOLVER Constants

• DBMS_BLOCKER_RESOLVER Exceptions

• Summary of DBMS_BLOCKER_RESOLVER Subprograms

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 AI Database 26ai. 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 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 2 DBMS_BLOCKER_RESOLVER Package

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 3 DBMS_BLOCKER_RESOLVER Package

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