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 -> How to interpret date values in a trace file?

How to interpret date values in a trace file?

From: <wagen123_at_yahoo.com>
Date: 26 Jan 2007 14:35:01 -0800
Message-ID: <1169850900.941793.186330@k78g2000cwa.googlegroups.com>


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 Received on Fri Jan 26 2007 - 16:35:01 CST

Original text of this message

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