My Oracle Support Banner

parallel with view query produces various Errors including ORA-600 [17147] or ORA-600 [17112] (Doc ID 2769279.1)

Last updated on APRIL 15, 2021

Applies to:

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

Symptoms

parallel with view query failed with ORA-600 [17147], ORA-600 [17112],
ORA-600 [15802], ORA-600 [qesnhBufferGetNew.1], ORA-7445 [rwsstd], ORA-7445
[kghalf] , ORA-7445 [kxfqRowCount], ORA-7445 [kgh_subtract_extent_chunks]
etc.

Mostly QC process hits memory corruption related error like ORA-600 [17XXX]
and PQ slaves encounter ORA-7445 and ORA-600  errors during the query
execution.


Symptoms  :

The query works well if
- executed in serial
- executed in parallel degree 5 or 6
- 10046 event trace is enabled
- 10384 event with level 16384
- "_px_scalable_gby_invdist" = false

The query fails if
- it's executed in parallel degree 4.
- "_slave_mapping_enabled" = false
- parallel_force_local=true


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!


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.