Re: Help - shutdown immedate take 10 mins to complete

On Sat, 25 Sep 2004 23:03:30 +0800, "adachi" <adachi_2003_at_yahoo.com.hk> wrote:

>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
>
>

shutdown immediate will wait for jobs to complete. period. If you don't want that
- either routinely issue shutdown abort - or revise your job strategy (5 job queue is a bit outrageous)

--
Sybrand Bakker, Senior Oracle DBA