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

4 votes113 views2 answers
Sql table
SQL
4 votes74 views1 answer
And or sql order of operations
SQL
0 vote115 views1 answer
Mysql docker image for macbook m1
SQL
0 vote116 views1 answer
Foreign key type uniqu mysql
SQL
0 vote117 views1 answer
Number(10 2) in sql means
SQL
2 votes114 views1 answer
Alter table add multiple columns postgresql
SQL
1 vote118 views3 answers
Mysql Server Start
SQL
0 vote121 views2 answers
Uninstall postgresql mac
SQL
1 vote165 views1 answer
SQL server query column yes or no
SQL
7 votes114 views1 answer
Mysql remote connection command line
SQL