parallel with view query produces various Errors including ORA-600  or ORA-600 
(Doc ID 2769279.1)
Last updated on APRIL 17, 2023
Applies to:Oracle Database - Enterprise Edition - Version 126.96.36.199.0 and later
Information in this document applies to any platform.
parallel with view query failed with ORA-600 , ORA-600 ,
ORA-600 , ORA-600 [qesnhBufferGetNew.1], ORA-7445 [rwsstd], ORA-7445
[kghalf] , ORA-7445 [kxfqRowCount], ORA-7445 [kgh_subtract_extent_chunks]
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
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
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