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 vote258 views1 answer
Tsql cmd exec script from file
SQL
6 votes253 views1 answer
Oracle rank() over (partition)
SQL
0 vote246 views1 answer
Sql examples from your work
SQL
2 votes293 views2 answers
Mysql does sentence contain word
SQL
2 votes278 views2 answers
Sqlalchemy filter or
SQL
0 vote283 views1 answer
Vbscript connect mssql
SQL
0 vote267 views1 answer
Monthly Birthday SQL Query
SQL
10 votes267 views1 answer
Oracle dba_dependencies
SQL
0 vote281 views1 answer
Kill slow queries mysql
SQL
0 vote261 views1 answer
Partitioning in oracle-base
SQL