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 vote334 views1 answer
Postgresql delete limit
SQL
0 vote329 views1 answer
Sql getdate minus 1 day without time
SQL
1 vote337 views1 answer
Postgresql not in
SQL
0 vote354 views1 answer
Cartesian product sql
SQL
0 vote318 views2 answers
Null value in column violates not-null constraint
SQL
0 vote312 views1 answer
Ora 00001 error catch plsql
SQL
5 votes344 views3 answers
Show indexes mysql
SQL
3 votes318 views3 answers
Django.db.utils.OperationalError: no such table:
SQL
38 votes331 views4 answers
Count sql
SQL
10 votes322 views4 answers
Inner join in update query mysql
SQL