Overview of Blocker Resolver

Blocker Resolver is an Oracle AI Database feature that automatically detects and resolves system delays.

Note:

Starting with Oracle AI Database 26ai, Oracle Quality of Service Management (QoSM, or QoS Management) is desupported.

Blocker Resolver initially identified system delays and then dumped the relevant information about the delay into a trace file. Blocker Resolver can take action on and attempt to resolve the system delay. Blocker Resolver also runs in both single-instance and Oracle RAC database instances.

Blocker Resolver functions, as follows:

• First detects a system delay and then analyzes the delay and verifies the cause of the delay. It then applies heuristics to decide on a course of action to resolve the delay.
• Automates the tasks that used to require manual steps by a DBA to provide the trace files to My Oracle Support so that someone there could identify the source of the delay, minimizing or eliminating database and application downtime.
• Periodically scans all processes and analyzes a smaller subset of processes that are holding resources in successive scans. Blocker Resolver ignores processes if there is nothing waiting on the resource.
• Considers cross-instance delays, which are delays where the holder is a database process waiting on a response from an Oracle ASM instance.
• Terminates the holder process so the next process waiting on that resource can move on and prevent a delay.
• Notifies a DBA with an ORA-32701 error message in the alert log.