Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to interpret date values in a trace file?

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

From: <yong321_at_yahoo.com>
Date: 27 Jan 2007 18:13:18 -0800
Message-ID: <1169950398.071789.116070@l53g2000cwa.googlegroups.com>


On Jan 27, 7:35 am, 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

I remember there was a bug for timestamp (type 180?) in SQL trace where bind value can't be displayed. Instead "Dump of memory from ..." follows. Open a Tar and let us know what Oracle says. There may be a published Metalink note about how to interpret timestamp in Oracle internal format (I know there's one for date).

Yong Huang Received on Sat Jan 27 2007 - 20:13:18 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US