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