How to use DBMS_SQLDIAG to Diagnose Crash or Error Issues (Doc ID 1360120.1)

Last updated on AUGUST 04, 2018

Applies to:

Goal

This article describes how to use DBMS_SQLDIAG to find workarounds for issues where a query causes a session to crash or raise a critical error.
The article is specifically designed to address ora-7445 errors but can be easily modified to deal with other issue types.

For other ways of using DBMS_SQLDIAG see:

This article is not intended to describe how to implement workarounds using the 'SQL Patch' functionality. It is intended to provide potential workaround for critical errors like an ORA-7445 error.
For details of how to apply 'SQL Patch' refer to the DBMS_SQLDIAG.ACCEPT_SQL_PATCH procedure. See:

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.