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: Job never start based on schedule

Re: Job never start based on schedule

From: sybrandb <sybrandb_at_yahoo.com>
Date: 30 May 2006 01:03:24 -0700
Message-ID: <1148976204.376385.261470@j33g2000cwa.googlegroups.com>


job_queue_processes is an init.ora parameter. You can verify the current setting by
show parameter job_queue_processes
You should also check whether you are using a server parameter file
(abbreviated spfile)

by issuing
show parameter spfile

(from the name of the init.ora it looks like you are using a spfile)

If that returns a file name you are using a spfile instead of init.ora

You should issue
alter system set job_queue_processes scope=memory|spfile|both to change it.

For backup purposes you could
create pfile='<filename>' from spfile

Further info in the docs.

Hth

-- 
Sybrand Bakker
Senior Oracle DBA
Received on Tue May 30 2006 - 03:03:24 CDT

Original text of this message

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