Re: Time stat from user dump

On Tue, 16 Nov 2004 11:31:44 -0500, Forte Agent <1443131_at_usenetplanet.com> wrote:

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

you can't
The number is meaningless.

--
Sybrand Bakker, Senior Oracle DBA