Re: The duration of one single oracle job

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Mon, 5 Jan 2009 12:48:46 +0100
Message-ID: <4961f39e$0$20448$426a74cc_at_news.free.fr>


"eteunisse" <eteunisse_at_gmail.com> a écrit dans le message de news: 37cd269a-b534-4797-baf8-420ac5832576_at_k36g2000pri.googlegroups.com...
| The question I have is simple and I thought I would find the answer in
| no time, but no luck.
| I user Oracle 10g, but we do not use the scheduler, but dbms_jobs.
|
| I have a job that gathers table statistics once a week.
| I want to know how long the last job execution took.
| In user_jobs there is the attribute TOTAL_TIME, but this is the total
| time this job executed in total.
| Of course I could remember the value of this before execution and
| afterwards it is easy to get what I want, but now O do not have the
| previous value and I need to know how long the last job took.
|
| Thanks

The answer is simple and short: you can't get it from dictionary. You have to do it by yourself.

Regards
Michel Received on Mon Jan 05 2009 - 05:48:46 CST

Original text of this message