Path: text.usenetserver.com!out02a.usenetserver.com!news.usenetserver.com!in02.usenetserver.com!news.usenetserver.com!cycny01.gnilink.net!spamkiller.gnilink.net!gnilink.net!trnddc08.POSTED!c015d11f!not-for-mail From: Chuck User-Agent: Thunderbird 2.0.0.9 (X11/20080220) MIME-Version: 1.0 Newsgroups: comp.databases.oracle.server Subject: Re: version_count References: <8498e608-6586-4fc7-8a0d-add4877f5e88@i12g2000prf.googlegroups.com> In-Reply-To: <8498e608-6586-4fc7-8a0d-add4877f5e88@i12g2000prf.googlegroups.com> X-Enigmail-Version: 0.95.6 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Lines: 46 Message-ID: Date: Fri, 04 Apr 2008 18:57:16 GMT NNTP-Posting-Host: 96.245.1.29 X-Complaints-To: abuse@verizon.net X-Trace: trnddc08 1207335436 96.245.1.29 (Fri, 04 Apr 2008 14:57:16 EDT) NNTP-Posting-Date: Fri, 04 Apr 2008 14:57:16 EDT Xref: usenetserver.com comp.databases.oracle.server:443433 X-Received-Date: Fri, 04 Apr 2008 13:57:16 EST (text.usenetserver.com) -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 joel garry wrote: | On Apr 4, 9:38 am, Chuck wrote: | 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 | 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." That makes sense. Different users with objects of the same name would require different cursors for the same SQL. That's not my case though. It's a peoplesoft database with a single application schema and everyone uses the same objects. | 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) http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:9497064796920 | http://www.freelists.org/archives/oracle-l/03-2004/msg03180.html | Dan's primer is pretty good summary of 11: http://www.psoug.org/reference/cursor_sharing.html | A view exists to tell you why: | http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/dynviews_2124.htm I'll check those links too. Thanks. -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.5 (GNU/Linux) Comment: Using GnuPG with PCLinuxOS - http://enigmail.mozdev.org iEYEARECAAYFAkf2egwACgkQzIf+rZpn0oSfGgCfYChqyWCwT9g4/IzVCAZtoSKy 3roAoJOEc9hx7AGKj3+fBsOBiaoovUOi =bCj0 -----END PGP SIGNATURE-----