RE: disable SNP job processing temporarily

[Jack van Zanen]

Title: disable SNP job processing temporarily

Would alter system set job_queue_processes = 0 be anoption???

 

 

Jack

-----Original Message-----
From: Markham, Richard [mailto:[EMAIL PROTECTED]]
Sent: maandag 4 november 2002 15:44
To: Multiple recipients of list ORACLE-L
Subject: disable SNP job processing temporarily

I have job_queue_processes 5 and job_queue_interval 3
I need to release locks on packages for a recompile
but ALTER SYSTEM ENABLE RESTRICTED SESSION; is not
always an option for me.  Does anyone know what I can
do to suspend job processing (with minimal impact).