Re: trace file

From: Danisment Gazi Unal (ubTools) <dunal_at_ubTools.com>
Date: Mon, 21 Jun 2004 11:44:57 +0300
Message-ID: <000f01c4576c$0a9f19e0$fe19100a@danismentgu>

Hi,

I assume that you mean event10046 trace file by raw trace file.

oacdef is a structure which keeps bind information. The flags for oacdef structure are oacflg and oacfl2. X$KXSBD.KXSBDOFL and X$KXSBD.KXSBDOF2 belong to oacflg and oacfl2, respectively. Here is a sample:

BINDS #2:
bind 0: dty=11 mxl=16(16) mal=00 scl=00 pre=00 oacflg=18 oacfl2=1 size=16 offset=0

bfp=01a94c7c bln=16 avl=16 flg=05
value=0000051A.0000.0001

In your case, there is no oacdef is created for your bind.

best regards...

http://www.ubTools.com
Web Based Oracle Products and Services

Original Message ----- From: <Satheesh.Babu_at_iflexsolutions.com> To: <oracle-l_at_freelists.org> Sent: Monday, June 21, 2004 10:05 AM Subject: trace file - oacdef

> Hi,
> In raw trace file I am seeing "(No oacdef for this bind)" what does
> this means?
>
> Thanks and Regards,
> Satheesh Babu.S
> 080-57593938
> Bangalore.
>
>
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Mon Jun 21 2004 - 03:41:12 CDT

Re: trace file - oacdef