Time stat from user dump

From: Forte Agent <1443131_at_usenetplanet.com>
Date: Tue, 16 Nov 2004 11:31:44 -0500
Message-ID: <mqakp0ppkqlt5lngglb0oj83foht9bgig6@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. Received on Tue Nov 16 2004 - 10:31:44 CST