Help - shutdown immedate take 10 mins to complete

From: adachi <adachi_2003_at_yahoo.com.hk>
Date: Sat, 25 Sep 2004 23:03:30 +0800
Message-ID: <cj42tb$22g2$1@news.hgc.com.hk>

Hi all,

Recently I had upgraded my client database from Oracle 7.3.3 on NT to 9.2.0.5.0 EE on HP-UX 64bit platform.

They had created a lot of jobs running in Oracle and the job_queue_processes is set to 5. Some jobs required around 5 minutes to complete and some jobs can be finished within 10 seconds.

When I shutdown the database using "shutdown immediate", it required a least 10 minutes to finish. But if I killed all ora_j00x processes before shutting down the database, the "shutdown immediate" completed within 10 seconds.

I had tried to change the job_queue_processes to zero before "shutdown immediate" but it doesn't work too.
I had tried to kill the job sessions using "alter system kill session..." but it took almost 5 to 10 minutes to complete.

Can somebody give me a hand on that? Thank you so much in advance.

Adachi Received on Sat Sep 25 2004 - 10:03:30 CDT