Re: Anybody know what oacflg and oacflg2 are?

nytimesjdarrah_at_hotmail.com (John) wrote in message news:<289173ea.0408241416.4457008_at_posting.google.com>...
> I'm looking at Note 39817.1 on Metalink which details how to read a
> raw 10046 trace. In the binds section, it has the following:
>
> oacflg Special flag indicating bind options
> oacflg2 Continuation of oacflg
>
> I'm wondering what these special bind options could be? Anyone know?

John,

I can't find the answer. But I notice that Danisment at http://www.freelists.org/archives/oracle-l/06-2004/msg01492.html says "X$KXSBD.KXSBDOFL and X$KXSBD.KXSBDOF2 belong to oacflg and oacfl2, respectively". (Note it's oacfl2, not oacflg2 as the Metalink note says.) The two columns of x$kxsbd map to shared_flag and shared_flag2 of v$sql_bind_data. According to 9i and 10g documentation, "System-generated binds have a value of 256 in the SHARED_FLAG2 column", which I can verify. But beyond that, I can't find anything. Since v$sql_bind_data is documented but the two columns are not well explained, I suggest you open a Tar with Oracle.

Yong Huang Received on Thu Aug 26 2004 - 14:48:40 CDT