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 vote306 views2 answers
Search stored procedures
SQL
1 vote323 views3 answers
Epoch to datetime
SQL
0 vote243 views0 answer
How to connect to datbase in springboot
SQL
0 vote298 views1 answer
Sql find all different values in column
SQL
7 votes370 views2 answers
3rd height salary sql
SQL
0 vote518 views1 answer
The SELECT permission has not been granted on 'sys.sql_logins' for the 'master' database. You must be a member of the 'loginmanager' role to access this system view.
SQL
0 vote302 views1 answer
Postgresql get diff between two dates in Months
SQL
1 vote313 views1 answer
Sql string function update replace
SQL
3 votes311 views1 answer
Alembic.util.exc.CommandError: Target database is not up to date.
SQL
0 vote293 views1 answer
Simple plsql program run in oracle sql developer but got the error
SQL