-
Query to get timing for DataFlows in Data Integrator
Posted on June 14th, 2007 No commentsselect dataflow_name, ROW_COUNT, to_date(START_time,’yyyy.mm.dd hh24:mi:ss’), to_date(end_time,’yyyy.mm.dd hh24:mi:ss’), trunc((EXECUTION_TIME/3600))’ Hr ‘trunc((EXECUTION_TIME – trunc((EXECUTION_TIME/3600))*3600)/60)’ Min’ as execution_time
from ALVW_FLOW_STAT
where OBJECT_TYPE = ‘Oracle Loader’
And dataflow_name =’&DF_NAME’
order by end_time desc


