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