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: Does Oracle Job cost a lot of System resource?

Re: Does Oracle Job cost a lot of System resource?

From: Dick <tingjun.li_at_gmail.com>
Date: 29 Jun 2006 18:22:46 -0700
Message-ID: <1151630565.949528.66850@x69g2000cwx.googlegroups.com>

Oxnard 写道:

> "Dick" <tingjun.li_at_gmail.com> wrote in message
> news:1151593943.173850.207730_at_p79g2000cwp.googlegroups.com...
> > Does Oracle Job cost a lot of System resources?
> >
> > variable myjob number;
> > /
> > begin
> > dbms_job.submit(:myjob,'pMovesheetTohistory(2,
> > 2);',trunc(sysdate)+36/24,'trunc(sysdate)+36/24');
> > end;
> > /
> > begin
> > dbms_job.run(:myjob);
> > end;
> > /
> >
> > Or should I write a program to call my procedure daily, - our system is
> > prepared to run for a very long time (maybe more than one year..)
> >
> > Any links or clues are appreciated.
> >
>
> no

What about running 80 jobs (or more)? Is there maximum number? Received on Thu Jun 29 2006 - 20:22:46 CDT

Original text of this message

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