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

Last updated on APRIL 17, 2023

Applies to:

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

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