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:[EMAIL PROTECTED]
-----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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
