Re: SQL ID with large Version Count encountered

Teresa Masino wrote:
> I cannot find any information on this message. We have a 10g
> environment that was just set up and we are regression testing
> applications in the new environment. I have several .trc files that
> log this message and I am trying to find out if there's something I can
> tweak to prevent these or if it's just life with 10g.
>
> *** ACTION NAME:(Auto-Flush Slave Action) 2006-03-05 11:01:00.845
> *** MODULE NAME:(MMON_SLAVE) 2006-03-05 11:01:00.845
> *** SERVICE NAME:(SYS$BACKGROUND) 2006-03-05 11:01:00.845
> *** SESSION ID:(1626.3419) 2006-03-05 11:01:00.845
> SQL ID with large Version Count encountered.
> SQL ID: 8z7xb2177z760
> Version Count: 292, Parse Calls: 139, Shareable Mem: 72480020
> Elapsed Time: 572012, CPU Time: 572012, Executions: 139
> Disk reads: 0, Buffer Gets: 7506, I/O Wait Class: 0
> Application WC: 0, Concurrency WC: 0, Cluster WC: 0
>
> It doesn't appear to be fatal as the users/testers are unaware of any
> problem. But I am curious that I see these all of a sudden.
>
> Thanks in advance for your input
> Teresa Masino
>

Something is buzzing... high version count (292), but just 139 parse and executes. Bad code (bind variables pop to mind).

Sorry, cannot point the finger into the exact location, but there you go - tune!

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...