APEX elapsed time

SELECT ELAPSED_TIME, numtodsinterval(ELAPSED_TIME, 'second') IV,
       extract(MINUTE FROM numtodsinterval(ELAPSED_TIME, 'second')) MI,
       extract(SECOND FROM numtodsinterval(ELAPSED_TIME, 'second')) SS
FROM APEX_WORKSPACE_ACTIVITY_LOG 
WHERE WORKSPACE = 'wks_name'
    AND APEX_USER = 'user_name'
    AND APPLICATION_ID = 'app_id';

Source: stackoverflow.com

Similar codes

0 vote218 views1 answer
Kill slow queries mysql
SQL
4 votes339 views6 answers
Laravel jwt
SQL
0 vote215 views1 answer
Install sql server in ubuntu 20.04
SQL
0 vote210 views1 answer
Mysql conf.d exampel
SQL
0 vote214 views1 answer
Connecting to my cloud sql server with c#
SQL
17 votes209 views6 answers
Current date in sql
SQL
1 vote205 views1 answer
Get all db sizes in mysql server
SQL
0 vote216 views1 answer
Get last three characters in mysql column
SQL
6 votes222 views4 answers
Mysql get random row
SQL
0 vote214 views1 answer
Plpgsql raise notice
SQL