Re: High Version count in V$SQLAREA

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 8 Jul 2003 06:10:30 -0700
Message-ID: <2687bb95.0307080510.2c4d671b@posting.google.com>

srivenu_at_hotmail.com (srivenu) wrote in message news:<1a68177.0307072253.60403427_at_posting.google.com>...
> Hi yong,
> Thanks for the reply.
> I dont think the versions are created due to change in bind lengths as
> they are issued by the same application (same part).
> As far as changes in optimizer parameters, i have to check it out. But
> version count of 100 is i think too much. is it not ?
> As far as i remember, I didn't change any optimizer parameters.
> regards
> Srivenu

We have seen the same issue. Actually Oracle support noticed the problem while working on trace files filed with an iTAR related to 04031 errors that started occuring after we upgraded to 64 bit Oracle from 32 bit. Support said the cursors, which are coming from packaged code, should be shared but are not. It is very possible what you are seeing is the result of coding/logic errors within Oracle's code.

HTH -- Mark D Powell -- Received on Tue Jul 08 2003 - 08:10:30 CDT