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 vote115 views1 answer
Join in update query in mysql
SQL
3 votes107 views2 answers
WhereIn SQL
SQL
0 vote118 views1 answer
Adding generated time in row mysql workbench
SQL
9 votes147 views1 answer
No sql
SQL
0 vote109 views1 answer
Like and not like together in sql
SQL
0 vote110 views1 answer
Parent: [Error: SQLITE_READONLY: attempt to write a readonly database] {
SQL
0 vote113 views1 answer
Repeatable read trong sql server
SQL
0 vote98 views1 answer
Export partttion and import in oracle
SQL
0 vote149 views1 answer
SQL SERVER Add Identity Column to existing table
SQL
0 vote98 views1 answer
Mysql last 6 months
SQL