Does Oracle Job cost a lot of System resource?

[Dick]

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.

[Michał Kuratczyk]

Dick wrote:
> Does Oracle Job cost a lot of System resources?

(...)

> Or should I write a program to call my procedure daily,

Do you really think that you can do that much better than Oracle did?
Just use what you paid for.

--
Michal Kuratczyk

[Oxnard]

"Dick" <tingj...@gmail.com> wrote in message
news:1151593943.1...@p79g2000cwp.googlegroups.com...

no

[Dick]

Michał Kuratczyk 写道：

Sorry, I might not declare the situation clear enough...

We currently have a server program running.. and it called our "logs
manager" daily (12:00), so we can aslo call procedure at the same time
for "table records manager(including move records to history_table and
delete record...)"

So did my first Job active Oracle's Job mechanism? Or Oracle itself has
many system Jobs running, and our newly added Job doesn't infulent it a
lot?

Thanks.

[Dick]

Oxnard 写道：

What about running 80 jobs (or more)? Is there maximum number?

[Michał Kuratczyk]

Dick wrote:
> What about running 80 jobs (or more)?

It only depends on what the jobs do. And if some of them require a lot of
resources just try not to run them simultaneously (and obviously not during
the peek usage of the system).

> Is there maximum number?
You are safe:
http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14237/limits004.htm#sthref4187
Job Queue Processes Maximum per instance 1000

Take a look here too:
http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14220/process.htm#sthref1597

--
Michal Kuratczyk

[Dick]

Michał Kuratczyk 写道：

Many thanks!!