Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: DBMS_JOB running history

Re: DBMS_JOB running history

From: Frank van Bortel <fvanbortel_at_netscape.net>
Date: Fri, 08 Apr 2005 14:29:28 +0200
Message-ID: <d35t8t$6ak$1@news6.zwoll1.ov.home.nl>


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

dba.orcl_at_gmail.com wrote:
> Is there an easy way to maintain/check history of DBMS_JOB?
> We have a snapshot refresh job scheduled for every 5 mins. Sometime it
> takes 2 mins to complete , sometime it takes 7 mins.
>
> We like to get an average time to refresh (based on all the runs in a
> single day).
>
> Any comments?
>
> Sami
>

What's wrong with your 5 minutes schedule, then? - --
Regards,
Frank van Bortel
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFCVnkofyJ9XXMPY5URAmRCAJ4wgoYJF+qnXtDXng46iKPrJBzjZACbBmga W0kkFYUwR83QSyUBJHN1Qgo=
=hvLq
-----END PGP SIGNATURE----- Received on Fri Apr 08 2005 - 07:29:28 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US