Re: Timestamp in the trace files

From: Mladen Gogala <no_at_email.here.invalid>
Date: Wed, 6 Jan 2010 18:02:07 +0000 (UTC)
Message-ID: <pan.2010.01.06.18.02.07_at_email.here.invalid>

On Wed, 06 Jan 2010 17:40:43 +0000, Mladen Gogala wrote:

> I am analyzing a trace file and the developer asked me when has this
> event taken place:
>
> =====================
> PARSING IN CURSOR #3 len=159 dep=0 uid=141 oct=3 lid=141
> tim=1233122414291746 hv=3402358638 ad='9a174550' select
> folderarti0_.segment# as col_0_0_, folderarti0_.FOLDER# as col_1_0_ from
> FOLDER_ARTICLES folderarti0_ where folderarti0_.segment# in (:1 , :2 ,
> :3 , :4)
> END OF STMT
>
> In other words, how can I convert the "tim" field into time and date?

Please ignore. I figured it out. The "tim" field represents the difference in microseconds. It's not the real time.That should be an improvement request that one would have to send to Oracle.

-- 
http://mgogala.byethost5.com

Received on Wed Jan 06 2010 - 12:02:07 CST