Oracle run_duration average

SELECT JOB_NAME,
       avg(extract(DAY FROM run_duration) * 24 * 60 * 60
               + extract(HOUR FROM run_duration) * 60 * 60
               + extract(MINUTE FROM run_duration) * 60
               + extract(SECOND FROM run_duration))
FROM DBA_SCHEDULER_JOB_RUN_DETAILS
WHERE JOB_NAME = 'my_job_name'
GROUP BY JOB_NAME;

Source: thatjeffsmith.com

Similar codes

0 vote108 views1 answer
How to get specific salary in sql
SQL
0 vote96 views1 answer
Mysql update privileges
SQL
0 vote99 views1 answer
Call rest api from postgresql
SQL
5 votes108 views1 answer
Ora-00054 resource busy and acquire with nowait
SQL
0 vote106 views1 answer
Change filed order in mysql
SQL
0 vote109 views1 answer
How to query all tables mysql at the same time
SQL
25 votes175 views6 answers
Change column name mysql
SQL
0 vote113 views1 answer
Select insert new table sql server
SQL
1 vote56 views1 answer
Alter user mysql native password
SQL
0 vote95 views1 answer
Oracle free up space in tablespace
SQL