Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Time stat from user dump
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