Re: Timestamp in the trace files

From: Maxim Demenko <mdemenko_at_gmail.com>
Date: Wed, 06 Jan 2010 19:37:14 +0100
Message-ID: <4B44D85A.7030204_at_gmail.com>

On 06.01.2010 19:02, Mladen Gogala wrote:
> 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.
>
>
>

May it help?
http://www.freelists.org/post/oracle-l/Oracle-10046-tim-e-and-ela-Values-use-Nanoseconds1024-not-Microseconds-on-some-Platforms

http://www.freelists.org/post/oracle-l/Trace-file-tim-values

Best regards

Maxim Received on Wed Jan 06 2010 - 12:37:14 CST