My Oracle Support Banner

FNDGSCST Gather Schema Statistics Completes With Error ORA-12801 and ORA-00600 (Doc ID 1068541.1)

Last updated on JULY 12, 2024

Applies to:

Oracle General Ledger - Version 11.5.10.2 and later
Information in this document applies to any platform.
FNDGSCST Gather Schema Statistics

Symptoms

When running Gather Schema Statistics for the GL schema, the program completes with an error:

Error
------
In GATHER_SCHEMA_STATS , schema_name= GL percent= 10 degree = 8 internal_flag= NOBACKUP
Error #1: ERROR: While GATHER_TABLE_STATS:
object_name=GL.GL_INTERFACE***ORA-12801: error signaled in parallel query server P006
ORA-00600: internal error code, arguments: [qkaffsindex3], [], [], [], [], [], [], []***

NOTE: Please see the following note which details the process to run Gather Schema Statistics:  How To Gather Schema Statistics for Oracle Applications (Doc ID 2877048.1)

Changes

 

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!

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