version_count
Date: Fri, 04 Apr 2008 16:38:40 GMT
Message-ID: <kQsJj.24$qB1.12@trnddc07>
-----BEGIN PGP SIGNED MESSAGE-----
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
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.5 (GNU/Linux)
Comment: Using GnuPG with PCLinuxOS - http://enigmail.mozdev.org
iEYEARECAAYFAkf2WZAACgkQzIf+rZpn0oTspACdFxt0gFkvXgtJ+kMh3oANr0s7
nwkAoJ8SS36nI0QHWoprM7ZMlSG3dhk+
=GE+T
-----END PGP SIGNATURE-----
Received on Fri Apr 04 2008 - 11:38:40 CDT