Path: text.usenetserver.com!out03a.usenetserver.com!news.usenetserver.com!in02.usenetserver.com!news.usenetserver.com!postnews.google.com!news1.google.com!border1.nntp.dca.giganews.com!border2.nntp.dca.giganews.com!nntp.giganews.com!cyclone1.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: 26 Message-ID: Date: Fri, 04 Apr 2008 19:13:58 GMT NNTP-Posting-Host: 96.245.1.29 X-Complaints-To: abuse@verizon.net X-Trace: trnddc08 1207336438 96.245.1.29 (Fri, 04 Apr 2008 15:13:58 EDT) NNTP-Posting-Date: Fri, 04 Apr 2008 15:13:58 EDT X-Original-Bytes: 1900 Xref: usenetserver.com comp.databases.oracle.server:443434 X-Received-Date: Fri, 04 Apr 2008 14:13:59 EST (text.usenetserver.com) -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 joel garry wrote: | A view exists to tell you why: | http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/dynviews_2124.htm Is there a better explanation of what each column means? For example I see a lot with BIND_MISMATCH = 'Y'. The doc simply says "The bind metadata does not match the existing child cursor". What is the bind metadata? Is it trying to say that maybe different data types were used for the bind variables by different executions of the SQL? I also see a lot where all columns = 'N' which still leaves me wondering why the cursor wasn't shareable. -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.5 (GNU/Linux) Comment: Using GnuPG with PCLinuxOS - http://enigmail.mozdev.org iEYEARECAAYFAkf2ffYACgkQzIf+rZpn0oTUMACaAgB0AU0KLrIJRDK8GlRvQgZu A28AnjfZL7iQnmK0fn5HdbLBUL4REMZW =X9ir -----END PGP SIGNATURE-----