High Number of Child Cursors for Queries using SPM due to HASH_MATCH_FAILED
(Doc ID 2210515.1)
Last updated on FEBRUARY 12, 2019
Applies to:Oracle Database - Enterprise Edition - Version 184.108.40.206 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.
- High version counts for many queries with HASH_MATCH_FAILED:
By definition, HASH_MATCH_FAILED means that no existing child cursors have the unsafe literal bind hash values required by the current cursor.
In such cases the query executed contains TIMESTAMP column. The TIMESTAMP column is marked as a none data literals so we are generating different hash for each none data literals each time function "Search Child List" is called and that's why the different child is created due to hash-mismatch(HASH_MATCH_FAILED=YES).
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