RE: job queue processes changing behind the scenes
- From: Josh Collier <Josh.Collier@xxxxxxxxxxxx>
- To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 5 Mar 2013 04:32:40 +0000
sorry there was a typo.
alter system set job_queue_processes=8 scope=both;
________________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx [oracle-l-bounce@xxxxxxxxxxxxx] on behalf
of Josh Collier [Josh.Collier@xxxxxxxxxxxx]
Sent: Monday, March 04, 2013 4:20 PM
To: oracle-l@xxxxxxxxxxxxx
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.
--
//www.freelists.org/webpage/oracle-l--
//www.freelists.org/webpage/oracle-l
Other related posts:
