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 vote105 views1 answer
Install mysql 5.7 ubuntu 20.04
SQL
1 vote120 views1 answer
Get the User Name and Domain Name from an Email Address
SQL
0 vote110 views1 answer
Cast float mysql
SQL
0 vote112 views1 answer
From _sqlite3 import * ImportError: DLL load failed: Das angegebene Modul wurde nicht gefunden.
SQL
0 vote98 views1 answer
Opensuse status MySQL
SQL
1 vote107 views1 answer
Oracle apex prevent initial load
SQL
3 votes143 views3 answers
Create table in SQL Server
SQL
0 vote96 views1 answer
Take sql dump in to file
SQL
0 vote105 views1 answer
Search mysql database for column
SQL
1 vote96 views1 answer
Postgresql must appear in the group by clause or be used in an aggregate function
SQL