1SELECT ELAPSED_TIME, numtodsinterval(ELAPSED_TIME, 'second') IV,
2 extract(MINUTE FROM numtodsinterval(ELAPSED_TIME, 'second')) MI,
3 extract(SECOND FROM numtodsinterval(ELAPSED_TIME, 'second')) SS
4FROM APEX_WORKSPACE_ACTIVITY_LOG
5WHERE WORKSPACE = 'wks_name'
6 AND APEX_USER = 'user_name'
7 AND APPLICATION_ID = 'app_id';