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

2 votes137 views2 answers
Change mysql password from command line
SQL
25 votes126 views3 answers
How to use a database to see tables mysql
SQL
0 vote137 views2 answers
SQLSTATE[HY000]: General error: 3780 Referencing column 'role_id' and referenced column 'id' in foreign key constraint 'user_role_id foreign' are incompatible.
SQL
0 vote119 views1 answer
SQL column name Oracle
SQL
0 vote116 views1 answer
Sql get date from timestamp
SQL
0 vote112 views1 answer
Sql cross apply vs join
SQL
0 vote120 views2 answers
Azure sql-datenbank
SQL
0 vote122 views1 answer
Sql server udf performance
SQL
0 vote129 views1 answer
Declare or use variable in snowflake
SQL
0 vote133 views1 answer
Mysql workbench primary key
SQL