Re: The duration of one single oracle job
From: Shakespeare <whatsin_at_xs4all.nl>
Date: Tue, 06 Jan 2009 21:52:21 +0100
Message-ID: <4963c485$0$188$e4fe514c_at_news.xs4all.nl>
eteunisse schreef:
> 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
Date: Tue, 06 Jan 2009 21:52:21 +0100
Message-ID: <4963c485$0$188$e4fe514c_at_news.xs4all.nl>
eteunisse schreef:
> 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
You could use flashback query to determine the old value ;-)
Shakespeare Received on Tue Jan 06 2009 - 14:52:21 CST