整数格式的timestamp怎么转化为DATE形式

avantar

Statistics Entry #413556 taken at timestamp 778329804
Statistic                 Value
-------------------------------
DB time                   44711793
DEFAULT cache read count  923033072
DEFAULT cache read time   9103778
shared pool load count    775928216
shared pool load time     14189873
java pool load count      258
java pool load time       40

请教下这种整数格式的timestamp怎么转化为DATE形式（YYYY-MM-DD HH24：MI:SS）

Maclean Liu(刘相兵

oradebug setmypid
oradebug dump DUMP_ADV_SNAPSHOTS 0

*** SERVICE NAME:(SYS$USERS) 2012-03-19 08:37:31.149
*** SESSION ID:(136.6) 2012-03-19 08:37:31.149
Dumping memory broker statistics snapshots 115
0: -----------------------------------------------------------
Statistics Entry #84 taken at timestamp 778321295
Statistic                 Value
-------------------------------
DB time                   447
DEFAULT cache read count  14767
DEFAULT cache read time   26
shared pool load count    5246
shared pool load time     16
java pool load count      0
java pool load time       0
Component              Granules
-------------------------------
DEFAULT cache          99
Shared Pool            88
Large Pool             28
Large Pool Freeable    0
Java Pool              4
Streams Pool           0
Free Memory            0
Default Cache Advice Version=4 Start Index of Version=26
Default Cache Granules -> Estimated Read Time
-----------------------------------------------


Statistics Entry #115 taken at timestamp 778322225
Statistic                 Value
-------------------------------
DB time                   448
DEFAULT cache read count  14849
DEFAULT cache read time   26
shared pool load count    5282
shared pool load time     16
java pool load count      0
java pool load time       0
Component              Granules
-------------------------------

timestamp FORMAT PROBLEM ?


Work IN PROCESS !!