RE: Setting job_queue

From: Reardon, Bruce (CALBBAY) <Bruce.Reardon_at_comalco.riotinto.com.au>
Date: Tue, 30 Jan 2001 13:45:14 -0800
Message-ID: <F001.002A5135.20010130134613@fatcity.com>

Hi Larry,

Under 815 on NT it is possible - can't say for sure on other versions / systems.
I did this from SQLPlus via a Net8 connection but should also work from svrmgrl.

Try " select * from v$parameter where name='job_queue_processes';" and see if it shows up as modifiable on your version / OS.

Then you can do a "alter system set job_queue_processes = 2;" to set the value.

Do something like:
select p.spid "Thread ID",

   b.name "Background Process",
   s.username "User Name",
   s.osuser "OS User",
   s.status "STATUS",
   s.sid "Session ID",
   s.serial# "Serial No.",
   s.program "OS Program"

from

v$process p, v$bgprocess b, v$session s where

s.paddr = p.addr and b.paddr(+) = p.addr order by 2 , 3 , 1
;

to confirm that the background process (a thread in NT) has started (under Unix I imagine you will be able to see the new process from the OS).

Hope this is what you meant.

Regards,
Bruce Reardon
mailto:bruce.reardon_at_comalco.riotinto.com.au

-----Original Message-----
Sent: Wednesday, 31 January 2001 8:26

Hi folks,

Is there a way to set the job_queue_processes parameter from svrmgrl while the database is up?

TIA
Larry
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Reardon, Bruce (CALBBAY)
INET: Bruce.Reardon_at_comalco.riotinto.com.au

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Jan 30 2001 - 15:45:14 CST

RE: Setting job_queue_processes