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 vote185 views1 answer
Connect by query in oracle
SQL
0 vote174 views1 answer
Mysql Install Ubuntu with native password
SQL
0 vote236 views1 answer
Tsql find procedure with name
SQL
0 vote193 views1 answer
Sub query in linq
SQL
1 vote201 views2 answers
Sql queries practice
SQL
0 vote182 views1 answer
Bus source and destination equal to destination and source of another by sql query
SQL
0 vote194 views1 answer
MySql Modify Increment
SQL
0 vote181 views1 answer
Get the previous column of a table in mysql
SQL
0 vote235 views1 answer
A network or instance-specific error sql server
SQL
0 vote182 views1 answer
Mysql create table like
SQL