job queue processes changing behind the scenes
From: Josh Collier <Josh.Collier_at_banfield.net>
Date: Tue, 5 Mar 2013 00:20:20 +0000
Message-ID: <D0534F8D31056242BE8E38FA9413FDA817E04D58_at_M1EXCHMB11.mmi.local>
10g R2
Linux
spfile only, I have deleted in init.ora file to avoid confusion the database is open
Date: Tue, 5 Mar 2013 00:20:20 +0000
Message-ID: <D0534F8D31056242BE8E38FA9413FDA817E04D58_at_M1EXCHMB11.mmi.local>
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-lReceived on Tue Mar 05 2013 - 01:20:20 CET