Re: trace file - oacdef
- From: "Danisment Gazi Unal (ubTools)" <dunal@xxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 21 Jun 2004 11:44:57 +0300
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@xxxxxxxxxxxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
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@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at //www.freelists.org/archives/oracle-l/
> FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
