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 vote210 views2 answers
Mysql insert into multiple tables
SQL
0 vote196 views1 answer
Mysql backup certain tables workbench
SQL
4 votes193 views1 answer
Change nls_date_format
SQL
0 vote203 views1 answer
How to remove default in mysql
SQL
2 votes244 views1 answer
Insert from table tsql
SQL
2 votes203 views2 answers
Laravel query builder toSql
SQL
0 vote196 views1 answer
Default order by in mysql
SQL
0 vote189 views1 answer
Postgresql create table many-to-many
SQL
-1 vote248 views3 answers
MAKE TABLE FIT in oracle sql
SQL
0 vote201 views1 answer
How to query all tables mysql at the same time
SQL