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

1 vote198 views1 answer
Add sequence postgres
SQL
-1 vote159 views1 answer
How to switch user in mysql
SQL
0 vote227 views1 answer
Month mysql
SQL
0 vote172 views1 answer
Mysql db dump restore max file size issue
SQL
0 vote188 views1 answer
Kill mysqld_safe process mariadb
SQL
1 vote168 views1 answer
Mysql list bigger table
SQL
0 vote188 views1 answer
Desinstaller mysql sur ubuntu definitivement
SQL
0 vote161 views1 answer
Connecting to my cloud sql server with c#
SQL
3 votes161 views2 answers
Postgres inner join vs join
SQL
0 vote188 views1 answer
Sql statement show all emails with dome
SQL