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 vote406 views1 answer
"Hello User Name"
SQL
6 votes429 views2 answers
Oracle undotbs usage
SQL
1 vote371 views1 answer
Partition by sql server
SQL
0 vote362 views1 answer
Object of class mysqli_result could not be converted to string
SQL
4 votes423 views2 answers
Postgresql float data type
SQL
4 votes335 views2 answers
How to count items with same name in sql
SQL
7 votes335 views4 answers
How to reset the identity column in sql server
SQL
3 votes386 views1 answer
Only join in sql
SQL
0 vote358 views1 answer
Joins vs includes
SQL
1 vote376 views1 answer
Age postgres
SQL