Flashback Table Fails ORA-600 [17092], [10388] And ORA-10388

(Doc ID 1198756.1)

Last updated on SEPTEMBER 19, 2011

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 11.1.0.6 - Release: 10.2 to 11.1
Information in this document applies to any platform.

Symptoms

Flashback table causes following error:

ORA-00600: internal error code, arguments: [17092], [10388], [], [], [], [], [], [], [], []

ORA-10388: parallel query server interrupt (failure)


With following conditions are met:

1. An ORA-600 [17092] [xxxx] is raised and the "xxxx" is an error code that is used for parallel execution inter-process communication, such as 10388.

2. Function qsmqcsm is in the call stack.

3. The current operation involves a Materialized View. 

4. Parallel queries are involved.

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