My Oracle Support Banner

ORA-7445 [qerixFetchFastFullScan] During Index Fast Full Scan On Exadata Database <= 21 (Doc ID 3055788.1)

Last updated on OCTOBER 26, 2024

Applies to:

Oracle Database - Enterprise Edition - Version 19.23.0.0.0 and later
Oracle Database Cloud Exadata Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Exadata Database Service on Exascale Infrastructure - Version N/A and later
Gen 2 Exadata Cloud at Customer - Version N/A and later
Generic Linux

Symptoms

ERROR
-----------
ORA-07445 [qerixFetchFastFullScan()+nnnn] [SIGSEGV]  occurred in Oracle Database running on Exadata system

 

Incident trace file shows on Plan table Index Fast Full Scan:

 

Plan Table
============
-------------------------------------------------------------------------------------+-----------------------------------+-------------------------+
| Id | Operation | Name | Rows | Bytes | Cost | Time | ObjectId | TQ |IN-OUT|PQ Distrib |
-------------------------------------------------------------------------------------+-----------------------------------+-------------------------+
...
| nn | INDEX STORAGE FAST FULL SCAN | <INDEX_NAME> 34M | 1198M | 151K | 00:31:02 | 284754 |:Q1002| PCWP | |
-------------------------------------------------------------------------------------+-----------------------------------+-------------------------+

 

Stack trace would usually have:

 

 

 

Changes

This issue affects storage servers for Exadata on-premises and Exadata Database Service on Dedicated Infrastructure (ExaDB-D)
and Cloud@Customer (ExaDB-C@C).

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Changes
Cause
Solution
References


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