Re: sqlplus shutdown "time-out"

When you shutdown abort, Instance Recovery requires rolling forward through the redo before opening the database. Rolling back the undo is done in the background.

You can shutdown abort, startup and logon to the database faster than you can shutdown immediate, startup and logon to the database.

Jared

On 4/21/05, Vitalis <vitalisman_at_gmail.com> wrote:
>
> On 4/21/05, Jared Still <jkstill_at_gmail.com> wrote:
> > On 4/20/05, Vitalis <vitalisman_at_gmail.com> wrote:
> > >
> > > (why use "abort" and force a recovery everytime while we could use
> > "immediate"
> > > in most cases?)
> > Because it is faster.
>
> I don't think so, if we're talking about delays caused by active
> transactions.
>
> The recovery would have to roll forward the updates that the initial
> transaction(s)
> had made; then Oracle would have to roll back the work again...
> AFAIK it would take longer because of the recovery.
>
> Jerome
>

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--
http://www.freelists.org/webpage/oracle-l