Re: SQL with High version count...

In article <1105993262.266225.53190_at_f14g2000cwb.googlegroups.com>, ibodogan says...
>
>I have an alert-system that generates the following report about SQLs
>with high number of versions:
>
>------------------------------------------
>VER : version count
>LVER: loaded versions
>UOP : users opening
>EXEC: executions
>PARS: parses
>LOAD: loads
>HVCR: high version count reason
>

....
>
>As seen in report, "INSERT INTO DEAnswer.." SQL has 158 different
>versions. Report also tells that the reason is BIND_MISMATCH (used
>V$SQL_SHARED_CURSOR to list the reasons)..but as seen in the report,
>the SQL is using bind variables (Actually apps don't use bind variables
>i set cursor_sharing to SIMILAR) so i couldn't figure out the root
>cause..
>
>is this high version count caused by log string variables or something
>else?
>

see
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:9497064796920

for the most likely cause.

>thanks,
>i.d.
>

-- 
Thomas Kyte
Oracle Public Sector
http://asktom.oracle.com/
opinions are my own and may not reflect those of Oracle Corporation