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

1 vote287 views2 answers
Install mysqldump ubuntu
SQL
0 vote384 views2 answers
Https://cloud.google.com/shell/docs/using-web-preview#previewing_the_application
SQL
1 vote303 views1 answer
Postgres set sequence value to max id
SQL
0 vote305 views1 answer
Exit psql
SQL
0 vote286 views1 answer
Sql order by number not ordered
SQL
0 vote278 views1 answer
Denormalise SQL command
SQL
0 vote299 views1 answer
Postgres clear table
SQL
0 vote273 views1 answer
Oracle flush Shared Pool
SQL
0 vote291 views1 answer
Mysql subtract month from timestamp
SQL
5 votes313 views4 answers
Traduction
SQL