Re: Executing a PL/SQL routine at regular intervels....

From: Jonathan Lewis <Jonathan_at_jlcomp.demon.co.uk>
Date: 1995/11/10
Message-ID: <816032258snz_at_jlcomp.demon.co.uk>#1/1


In article <47u05m$rlp_at_news.iastate.edu>

           ramirez_at_iastate.edu "Richard G Ramirez" writes:

:
: We are using Oracle 7.1 and we just tried doing the same thing.
: After we changed INIT.ORA to allow DBMS.JOB to schedule jobs,
: it created an extra Unix process (one for each job queue),
: and they used a lot of CPU time (3 min / hr) without a job
: scheduled. When we scheduled a job (only one) to run once a day,
: it used up 95% of the CPU time.
:

What is your platform, and interval did you set ?

-- 
Jonathan Lewis
Received on Fri Nov 10 1995 - 00:00:00 CET

Original text of this message