Re: version_count

From: joel garry <>
Date: Fri, 4 Apr 2008 10:34:56 -0700 (PDT)
Message-ID: <>

On Apr 4, 9:38 am, Chuck <> wrote:
> Hash: SHA1
> Can someone please give me an explanation, or point me to a URL which
> has one, of what v$sqlarea.version_count is all about? I understand it
> has to do with the # of child cursors for a given SQL in the library
> cache, but why would you need more than one cursor? Is that cursor not
> shareable? What would make a cursor not shareable? Does it have to do
> with different execution plans for the same SQL but with different bind
> variables? Or is it simply the # of sessions running the same SQL at he
> same time? TIA
> Version: GnuPG v1.4.5 (GNU/Linux)
> Comment: Using GnuPG with PCLinuxOS -
> iEYEARECAAYFAkf2WZAACgkQzIf+rZpn0oTspACdFxt0gFkvXgtJ+kMh3oANr0s7
> nwkAoJ8SS36nI0QHWoprM7ZMlSG3dhk+
> =GE+T
From the performance manual: "A SQL statement can map to multiple cursors, because the objects referred to in the cursor can differ from user to user."

There's lots of explanations on the web and in books. Here's a good start (found by searching for v$sqlarea.version_count on asktom.oraclecom)

Dan's primer is pretty good summary of 11:

A view exists to tell you why:


-- is bogus.
That darn internet.
Received on Fri Apr 04 2008 - 12:34:56 CDT

Original text of this message