Re: [Oracle8i] Jobs

From: Tiago Rocha <please.see.link.at.signature.for.email.address_at_zaz.com.br>
Date: Wed, 18 Feb 2004 17:38:03 -0300
Message-ID: <fti730tcqu6k78emk7fftr68okptqbe50r@4ax.com>

On Wed, 18 Feb 2004 18:43:21 +0100, "szalas" <gszalach_at_hotmail.com> wrote:

>Hi,
>How many jobs can be submited in Oracle at the same time ? (does any
>parameter say about this ?)

SQL> select name,
  2 description
  3 from v$parameter
  4 where name in ( 'job_queue_processes',

  5                  'job_queue_interval' );

NAME

---

DESCRIPTION

---

job_queue_processes
number of job queue processes to start

job_queue_interval
Wakeup interval in seconds for job queue processes

--
These parameters can be changed on the init file for the instance... usually init.ora.
job_queue_processes is the parameter that defines the limit. There is a max number that you can put
there... Don't remember, better check documentation at tahiti.oracle.com. If the value of this
parameter is zero, no jobs will run, but they can be submitted.



>How can I find out how many jobs are submited and what their states are in

>the pl/sql procedure ?


select * from user_jobs or 
select * from dba_jobs

too see the jobs that are running:

select * from dba_jobs_running



>Thank you very much for your answers

>Szalas

>


-- 
Tiago Rocha
Recife - Brasil
www.diariodastrilhas.cjb.net

Received on Wed Feb 18 2004 - 14:38:03 CST