set lines 200
set pages 200
col object_name for a30
select a.obj#,b.object_name,
a.analyzetime,
to_char(a.savtime, 'yyyy-mm-dd hh24:mi:ss'),
to_number((to_date(to_char(a.savtime, 'yyyy-mm-dd hh24:mi:ss'),
'yyyy-mm-dd hh24:mi:ss') -
to_date(to_char(a.analyzetime, 'yyyy-mm-dd hh24:mi:ss'),
'yyyy-mm-dd hh24:mi:ss')) * 24) hours
from wri$_optstat_tab_history a,dba_objects b
where a.obj#=b.object_id;
OBJ# OBJECT_NAME ANALYZETI TO_CHAR(A.SAVTIME,' HOURS
---------- ------------------------------ --------- ------------------- ----------
5232 UTL_RECOMP_SORTED 13-MAY-22 2022-05-13 09:49:07 0
5232 UTL_RECOMP_SORTED 13-MAY-22 2022-05-13 09:49:07 .000277778
5232 UTL_RECOMP_SORTED 13-MAY-22 2022-05-13 09:49:06 .001111111
5232 UTL_RECOMP_SORTED 13-MAY-22 2022-05-13 09:49:02 .000277778
5232 UTL_RECOMP_SORTED 05-APR-22 2022-05-13 09:49:01 921.790556
5233 UTL_RECOMP_COMPILED 13-MAY-22 2022-05-13 09:49:07 0
5233 UTL_RECOMP_COMPILED 13-MAY-22 2022-05-13 09:49:07 .000277778
5233 UTL_RECOMP_COMPILED 13-MAY-22 2022-05-13 09:49:06 .001111111
5233 UTL_RECOMP_COMPILED 13-MAY-22 2022-05-13 09:49:02 .000277778
5233 UTL_RECOMP_COMPILED 05-APR-22 2022-05-13 09:49:01 921.790556
107334 AQ$_KUPC$DATAPUMP_QUETAB_1_P 2022-05-13 09:45:28
107279 KUPC$DATAPUMP_QUETAB_1 2022-05-13 09:45:27
107426 T1 2022-05-17 10:47:03
107532 REGIONS 2022-05-17 15:30:43
107534 COUNTRIES 2022-05-17 15:30:43
107536 LOCATIONS 2022-05-17 15:30:43
107539 DEPARTMENTS 2022-05-17 15:30:43
107542 JOBS 2022-05-17 15:30:43
107544 EMPLOYEES 2022-05-17 15:30:43
107548 JOB_HISTORY 2022-05-17 15:30:43