Re: version_count

From: Chuck <skilover_nospam_at_bluebottle.com>
Date: Fri, 04 Apr 2008 19:13:58 GMT
Message-ID: <W5vJj.38$Ah1.37@trnddc08>


-----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-----
Received on Fri Apr 04 2008 - 14:13:58 CDT

Original text of this message