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 vote211 views1 answer
How to do a function to return row type from a table in pl/sql
SQL
0 vote226 views1 answer
In query in sql
SQL
1 vote197 views1 answer
How to select random rows from table
SQL
0 vote218 views1 answer
Kill slow queries mysql
SQL
0 vote211 views1 answer
Write a PL/SQL to print even numbers upto 100.
SQL
0 vote212 views1 answer
Mysql read row
SQL
0 vote194 views1 answer
Dump only schema
SQL
0 vote218 views1 answer
Plsql check how much space all databases are consuming
SQL
1 vote199 views1 answer
Sql get missing id
SQL
1 vote209 views1 answer
How to start with sql
SQL