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 vote197 views1 answer
Implizite joins sql
SQL
8 votes234 views3 answers
Find table for column name in sql
SQL
0 vote196 views1 answer
Remove from table where
SQL
0 vote264 views1 answer
Mysql installer no packages found
SQL
0 vote197 views1 answer
Csv to sqlite python
SQL
0 vote199 views1 answer
Postgres add prefix to primary key
SQL
0 vote206 views2 answers
Laravel: customize or extend notifications - database model
SQL
0 vote195 views1 answer
How to start my sql server on mac
SQL
0 vote260 views1 answer
Sql ssrs
SQL
0 vote255 views1 answer
Mysl like insert a variable
SQL