RE: job queue processes changing behind the scenes

From: Josh Collier <Josh.Collier_at_banfield.net>
Date: Tue, 5 Mar 2013 04:32:40 +0000
Message-ID: <D0534F8D31056242BE8E38FA9413FDA817E04DF2_at_M1EXCHMB11.mmi.local>

sorry there was a typo.

alter system set job_queue_processes=8 scope=both;

---

From: oracle-l-bounce_at_freelists.org [oracle-l-bounce_at_freelists.org] on behalf of Josh Collier [Josh.Collier_at_banfield.net] Sent: Monday, March 04, 2013 4:20 PM
To: oracle-l_at_freelists.org
Subject: job queue processes changing behind the scenes

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.

--
http://www.freelists.org/webpage/oracle-l--
http://www.freelists.org/webpage/oracle-l

Received on Tue Mar 05 2013 - 05:32:40 CET