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
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 LewisReceived on Fri Nov 10 1995 - 00:00:00 CET