Prev: Oracle DBA Required Urgently in Blythewood, SC
Next: Quick move tablespace
From: Mladen Gogala on 6 Jan 2010 12:40

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?


--
http://mgogala.byethost5.com
From: Mladen Gogala on 6 Jan 2010 13:02
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
From: Paulie on 6 Jan 2010 13:22


> > tim=1233122414291746

> > 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.


How old is this developer? What is the database and OS?

I'm really very impressed with this statistic because apparently
some process has been running flawlessly on that machine
for more than 39 years (1233122414/60/60/24/365 ~= 39.1).


Paul...


> --http://mgogala.byethost5.com

From: Jonathan Lewis on 6 Jan 2010 13:24


"Mladen Gogala" <no(a)email.here.invalid> wrote in message
news:pan.2010.01.06.18.02.07(a)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


From: Maxim Demenko on 6 Jan 2010 13:37
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
 |  Next  |  Last
Pages: 1 2 3
Prev: Oracle DBA Required Urgently in Blythewood, SC
Next: Quick move tablespace