Re: Loooooong wait to shutdown Oracle immediate on Linux

From: joel garry <joel-garry_at_home.com>
Date: Wed, 24 Feb 2010 08:57:44 -0800 (PST)
Message-ID: <65055092-963b-402c-b7bf-8261d080c2cc_at_a16g2000pre.googlegroups.com>



On Feb 24, 2:21 am, Jia Lu <roka..._at_gmail.com> wrote:
> hi all
>
>  I have oracle 10g and 11g online on linux.
>  But after 1 month when I do shutdown immediate command, it took a
> long loooong time wait just like it freezed.
>  Is there anyone have the same experience?
>
>  Best Laurence Lu

You might check what is attached to the db. It could be an agent session. Kill all sessions, then check what is still attached. It could be a rollback as Michel said. If it's an agent session or something else non-transaction, kill the process at the OS level. If it's a session that has been in killed state for a month, kill its process.

jg

--
_at_home.com is bogus
Faster Pussycat!  Kill Kill!
Received on Wed Feb 24 2010 - 10:57:44 CST

Original text of this message