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 vote257 views1 answer
Postgres can integer fields be negative
SQL
1 vote234 views1 answer
Access the postgres psql
SQL
0 vote230 views1 answer
Make a socket server to detect changes in mysql
SQL
6 votes224 views1 answer
SQL insert all columns
SQL
-2 votes235 views3 answers
Oracle tablespace usage
SQL
2 votes218 views2 answers
Function in sql
SQL
1 vote253 views1 answer
Mysql connect bash
SQL
1 vote221 views1 answer
Can not connect to mysql server
SQL
0 vote257 views1 answer
Mysql Selected All Duplicate Rows
SQL
5 votes221 views1 answer
Oracle get nls settings
SQL