Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Time stat from user dump

Re: Time stat from user dump

From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 17 Nov 2004 05:29:19 -0800
Message-ID: <92eeeff0.0411170529.5f27f79d@posting.google.com>


Forte Agent <1443131_at_usenetplanet.com> wrote in message news:<mqakp0ppkqlt5lngglb0oj83foht9bgig6_at_4ax.com>...
> There are time statistics in database user session trace file shown
> below, such as "tim=506201648":
>
> 347 =====================
> 348 PARSING IN CURSOR #1 len=32 dep=0 uid=0 oct=3 lid=0
> tim=506201648 hv=428662531 ad='65dc2914'
> 349 select count(*) from dba_objects
> 350 END OF STMT
> 351 PARSE
> #1:c=1181699,e=1292000,p=6,cr=69,cu=0,mis=1,r=0,dep=0,og=4,tim=506201648
> 352 EXEC
> #1:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=506251648
> 353 FETCH
> #1:c=260375,e=1683000,p=262,cr=40257,cu=0,mis=0,r=1,dep=0,og=4,tim=507944648
> 354 FETCH
> #1:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=0,tim=507954648
>
> How can I convert these time statistics to human readable time, such
> as in 'YYYY/MM/DD HH24:MI:SS' format? Thank you in advance.

This is from Metalink docid 39817.1

[tim]
Timestamp.
Pre-Oracle9i, the times recorded by Oracle only have a resolution of 1/100th of a second (10mS). As of Oracle9i some times are available to microsecond accuracy (1/1,000,000th of a second). The timestamp can be used to determine times between points in the trace file. The value is the value in V$TIMER when the line was written. If there are TIMESTAMPS in the file you can use the difference between 'tim' values to determine an absolute time.

Regards
/Rauf Received on Wed Nov 17 2004 - 07:29:19 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US