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 vote114 views0 answer
SQL
0 vote158 views2 answers
How to display enum value sql server
SQL
0 vote151 views2 answers
Create row number in sql
SQL
14 votes166 views4 answers
Online sql compiler
SQL
1 vote148 views1 answer
Select if then postgresql
SQL
0 vote158 views1 answer
Get foreign table names mysql
SQL
1 vote152 views1 answer
Clear screen command in psql
SQL
3 votes148 views2 answers
Sql asc
SQL
3 votes147 views1 answer
How to calculate number of days between two dates excluding weekends in oracle
SQL
0 vote161 views1 answer
How to find total working hour in sql
SQL