Re: sqlplus shutdown "time-out"
- From: Jared Still <jkstill@xxxxxxxxx>
- To: Vitalis <vitalisman@xxxxxxxxx>
- Date: Thu, 21 Apr 2005 16:02:22 -0700
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@xxxxxxxxx> wrote:
>
> On 4/21/05, Jared Still <jkstill@xxxxxxxxx> wrote:
> > On 4/20/05, Vitalis <vitalisman@xxxxxxxxx> 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
