<div>
Yes, I offered to my client to create a job_log_table (+proc) but they rejected to add extra table to the production invirontment.<br />
<br />
It is surprising that powerful Oracle does not have such simple statistic/historical information about jobs executions.<br />
<br />
Any way, thanks guys for your attention.
</div>


Yes, I offered to my client to create a job_log_table (+proc) but they rejected to add extra table to the production invirontment.

It is surprising that powerful Oracle does not have such simple statistic/historical information about jobs executions.

Any way, thanks guys for your attention.

<div>
wow I get the answer AND the assist. &nbsp;You must have really liked my answers. &nbsp;<br />
<br />
Thanks!<br />
<br />
:)
</div>


wow I get the answer AND the assist.  You must have really liked my answers.  

Thanks!

:)

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
Is it any way to find out an execution (elapse) time for the job?<br />
<br />
ALL_JOBS.TOTAL_TIME seams indicating a cumulative processing time for a job rather then time per each execution.
</div>
</div>


Hi,

Is it any way to find out an execution (elapse) time for the job?

ALL_JOBS.TOTAL_TIME seams indicating a cumulative processing time for a job rather then time per each execution.

Is it any way to find out an execution (elapse) time for the job?

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.