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 vote181 views1 answer
Mysql list bigger table
SQL
1 vote197 views1 answer
Mysql select for update ejemplo
SQL
4 votes185 views1 answer
Oracle error line
SQL
16 votes179 views3 answers
Tsql rename column name
SQL
0 vote177 views1 answer
Adonisjs ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
4 votes251 views2 answers
Delete all table oracle
SQL
0 vote188 views1 answer
Port 5432 is already in use Usually this means that there is already a PostgreSQL server running on your Mac. If you want to run multiple servers simultaneously, use different ports.
SQL
-1 vote183 views3 answers
Create temp table in sql
SQL
0 vote176 views1 answer
Where in clause tsql
SQL
-1 vote168 views1 answer
What is in operator
SQL