Re: Unable to shutdown the database

From: John Hurley <johnthehurley_at_gmail.com>
Date: Mon, 5 Nov 2012 04:29:58 -0800 (PST)
Message-ID: <74450804-fd54-470c-bef5-d4324aaf6b8a_at_q16g2000yqc.googlegroups.com>

On Nov 4, 11:36 pm, Mladen Gogala <gogala.mla..._at_gmail.com> wrote:
> On Sat, 03 Nov 2012 10:56:15 -0700, John Hurley wrote:
> > Block cleanout and various kinds of oracle housekeeping can occur after
> > a database restart.
>
> Block cleanout doesn't occur on the instance startup, it occurs when the
> blocks that need the old lock and session information removed are
> referenced. That means that the block cleanout will happen during a query,
> not during the instance start.
>
> The practice of doing abort/start/shutdown is, of course, wrong. The most
> likely reason for the "hanging" is, of course, recovery. Zigzagdna is an
> old customer here who seems to be opposed to reading literature and using
> the accepted methods of testing stuff. This is rather typical example of
> the self inflicted problems that he usually comes up with. I tend to
> ignore his posts.
>
> --

I said can occur "after" ... not because of ... Received on Mon Nov 05 2012 - 13:29:58 CET