SQL High Version count
Hi, we've encountered a single high version counted SQL statement with the AWR reports, in the thousands.
The reasons for the high versions are AUTH_CHECK_MISMATCH and TRANSLATION_MISMATCH.
The Oracle supplied diagnostic report produces this from a development environment:
COLUMN_VALUE
--------------------------------------------------------------------------------
Note:438755.1 Version Count Report Version 3.2.4 -- Today's Date 02-dec-15 13:59
RDBMS Version :12.1.0.2.0 Host: ES-SUN01 Instance 1 : DVCRRNT
==================================================================
Addr: 000000042AF565E0 Hash_Value: 627877064 SQL_ID 7t8cycckqt968
Sharable_Mem: 21595998 bytes Parses: 847 Execs:847
Stmt:
<Statement text removed>
Versions Summary
----------------
AUTH_CHECK_MISMATCH :846
TRANSLATION_MISMATCH :846
Total Versions:846
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
cursor_sharing = EXACT
_cursor_obsolete_threshold = 1024 (See Note:10187168.8)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Plan Hash Value Summary
-----------------------