Re: Timestamp in the trace files
Date: Wed, 6 Jan 2010 18:24:08 -0000
"Mladen Gogala" <no_at_email.here.invalid> wrote in message
> 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.
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.comReceived on Wed Jan 06 2010 - 12:24:08 CST