Re: Timestamp in the trace files

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Wed, 6 Jan 2010 18:24:08 -0000
Message-ID: <WKmdnXwZTfXbSNnWnZ2dnUVZ8lmdnZ2d_at_bt.com>


"Mladen Gogala" <no_at_email.here.invalid> wrote in message news: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

Isn't it (often) the time in microseconds since the machine started ?

I believe I've also seen cases on older version, and different platforms of it being

    time in nanoseconds,
    and time since

        instance started
        1-Jan-1970

-- 
Regards

Jonathan Lewis
http://jonathanlewis.wordpress.com 
Received on Wed Jan 06 2010 - 12:24:08 CST

Original text of this message