oracle apex call duration

Solutions on MaxInterview for oracle apex call duration by the best coders in the world

showing results for - "oracle apex call duration"
Arianna
06 Feb 2017
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';