OQueries with large number of versions. HASH_MATCH_FAILED.
EE 12.1.0.2 running on Linux
CURSOR_SHARING=FORCE
ADDM lists Hard Parse Due to Sharing Criteria as one of it's concerns. Doing a little research I found that HASH_MATCH_FAILED is the most common culprit.
HASH_MATCH_FAILED 38461
ROLL_INVALID_MISMATCH 23576
BIND_EQUIV_FAILURE 4174
...
Looking at a query that has 1024 children that is being parsed due to HASH_MATCH_FAILED it appears that the query is fine. The query uses bind variables and doesn't use any timestamp columns.
Statistics and histograms are current.
I have 36 other queries with the same problem (1024 children and HASH_MATCH_FAILED).
Any hints on getting to the bottom of this? What haven't I looked at.