Re: Help - shutdown immedate take 10 mins to complete

• Post for FREE via your newsreader at post.usenet.com ****

Sybrand Bakker wrote:

> 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

We run a kill script as part of our shutdown immediate procedure. I think that is a valid technique if you want the database to come down "now".

HTH -- Mark D Powell --

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

• Usenet.com - The #1 Usenet Newsgroup Service on The Planet! *** http://www.usenet.com Unlimited Download - 19 Seperate Servers - 90,000 groups - Uncensored -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=