Re: job queue processes changing behind the scenes

  • From: Fuad Arshad <fuadar@xxxxxxxxx>
  • To: "Josh.Collier@xxxxxxxxxxxx" <Josh.Collier@xxxxxxxxxxxx>
  • Date: Mon, 4 Mar 2013 18:56:48 -0600

I don't see a reset here which is why it seems to be retaining the old value 

Fuad


On Mar 4, 2013, at 18:20, Josh Collier <Josh.Collier@xxxxxxxxxxxx> wrote:

> 10g R2
> Linux
> spfile only, I have deleted in init.ora file to avoid confusion
> the database is open
> 
> show parameters  job queue processes 2
> alter database set job_queue_processes scope=both;
> shutdown abort
> startup nomount
> show parameter job
> job_queue_processes=2
> 
> what could be changing the parameter behind the scenes on me. I suspect a bug.
> 
> 
> 
> --
> //www.freelists.org/webpage/oracle-l
> 
> 
--
//www.freelists.org/webpage/oracle-l


Other related posts: