Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: sqlplus shutdown "time-out"

Re: sqlplus shutdown "time-out"

From: Connor McDonald <mcdonald.connor_at_gmail.com>
Date: Fri, 22 Apr 2005 09:02:34 +0800
Message-ID: <5e3048620504211802217fd98c@mail.gmail.com>


Its the old fear of the word "abort". If Oracle had done the right thing from day 1 and named

shutdown as "60 minute pause"
shutdown immediate as "shutdown slow"
shutdown abort as "shutdown fast"

well, we all know what everyone would be using=20

:-)

On 4/22/05, Jared Still <jkstill_at_gmail.com> wrote:
> 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.

>=20

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

> Jared

>=20

--=20
Connor McDonald
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D
email: connor_mcdonald_at_yahoo.com
web: http://www.oracledba.co.uk

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Apr 21 2005 - 21:06:46 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US