ORA-7445 [qervwRestoreViewBufPtrs()+175] (Doc ID 1606223.1)

Last updated on JUNE 28, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 and later
Information in this document applies to any platform.

Symptoms

On versions above 11.2.0.1, during CTAS with a number of nested joins, the database loses connection with error ORA-3113 reported on the client.  The alert log shows
an ORA-7445 [qervwRestoreViewBufPtrs()+175]. The Call Stack in the trace file written by the error contains all or some of the following functions:

qervwRestoreViewBufPtrs <- qervwFetchPtrs <- qerjoFetch <- qerjoFetch <- qerjotFetch <- qerghFetch

 

The query plan of the failing query (which can be found in the trace file) is similar to the following:

============
Plan Table
============
----------------------------------------------------------------------+-----------------------------------+
| Id  | Operation                                  | Name             | Rows  | Bytes | Cost  | Time      |
----------------------------------------------------------------------+-----------------------------------+
| 0   | CREATE TABLE STATEMENT                       
| 1   |  LOAD AS SELECT                            
| 2   |   HASH UNIQUE                               
| 3   |    NESTED LOOPS                          
| 4   |     NESTED LOOPS OUTER              
| 5   |      NESTED LOOPS OUTER          
| 6   |       VIEW                                 
| 7   |        HASH JOIN OUTER                    
| 8   |         HASH JOIN OUTER                  
| 9   |          HASH JOIN OUTER                  
| 10  |           HASH JOIN OUTER                
| 11  |            HASH JOIN OUTER                
| 12  |             HASH JOIN OUTER              
| 13  |              HASH JOIN OUTER              
| 14  |               NESTED LOOPS                
| 15  |                TABLE ACCESS BY INDEX ROWID
| 16  |                 INDEX UNIQUE SCAN         
| 17  |                TABLE ACCESS FULL          
| 18  |               TABLE ACCESS FULL           
| 19  |              TABLE ACCESS FULL            
| 20  |             TABLE ACCESS FULL             
| 21  |            TABLE ACCESS FULL             
| 22  |           TABLE ACCESS FULL              
| 23  |          TABLE ACCESS FULL                
| 24  |         TABLE ACCESS FULL                
| 25  |       INDEX RANGE SCAN                    
| 26  |      TABLE ACCESS BY INDEX ROWID          
| 27  |       INDEX RANGE SCAN                   
| 28  |     INDEX RANGE SCAN                      
----------------------------------------------------------------------+-----------------------------------+

.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms