Re: How to interpret date values in a trace file?

On Jan 26, 5:35 pm, wagen..._at_yahoo.com wrote:
> Oracle10g RAC 10.2.0.2 (64 bit)
> RHEL AS 4.4 (64 bit)
>
> How does one interpret the date values from a trace file? Information
> from the raw trace file (from the bind information section) - Bind#5
> and #6 are date values. The query has this format - between
> TO_DATE('xx/xx/xxxx','MM/DD/YYYY') and
> TO_DATE('xx/xx/xxxx','MM/DD/YYYY'))
>
> Bind#5
> oacdty=180 mxl=11(11) mxlc=00 mal=00 scl=00 pre=00
> oacflg=03 fl2=1000000 frm=01 csi=873 siz=0 off=352
> kxsbbbfp=2a973b6d38 bln=11 avl=11 flg=01
> value=
> Dump of memory from 0x0000002A973B6D38 to 0x0000002A973B6D43
> 2A973B6D30 1C0A6A78 1520130F [xj.... .]
> 2A973B6D40 974075C1 [.u@.]
> Bind#6
> oacdty=180 mxl=11(11) mxlc=00 mal=00 scl=00 pre=00
> oacflg=03 fl2=1000000 frm=01 csi=873 siz=0 off=368
> kxsbbbfp=2a973b6d48 bln=11 avl=11 flg=01
> value=
> Dump of memory from 0x0000002A973B6D48 to 0x0000002A973B6D53
> 2A973B6D40 1A016B78 1520130F [xk.... .]
> 2A973B6D50 034075C1 [.u@.]
>
> Thanks for any help/pointers.
> wagen

Did you look at http://asktom.oracle.com or do any searches against cdos ... this information has been discussed repeatedly. Received on Fri Jan 26 2007 - 18:47:54 CST