RE: Date bind variable being peeked, but not used for cardinality estimate
Date: Thu, 24 Sep 2009 09:50:19 -0700
It was news to me that the variables in v$sql_bind_capture aren't necessarily the ones used for peeking - I had misunderstood that until now that you and a few others have enlightened me.
Thanks for the pointer to the Metalink note - I have read that, but I'm not sure yet if that's my problem or not. This is an Oracle Forms app running on Oracle Application Server 10.1.2.3, so it is a Java application on the client side but I was under the impression that the Forms server process (frmweb) running on the app server connected to the database through a regular OCI/Oracle Net connection (not sure how to confirm that though). Also, the note says that JDBC drivers 10g+ do not have this problem and I'd think that if Oracle forms is actually using jdbc, it would at least be 10g+ since it's 10g app server running on a 10g database.
I've got an SR open for this now so I'll reply back to the list when we figure it out.
Privileged/Confidential Information may be contained in this message or attachments hereto. Please advise immediately if you or your employer do not consent to Internet email for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of this company shall be understood as neither given nor endorsed by it.Received on Thu Sep 24 2009 - 11:50:19 CDT