Re: Type of shutdown

From: <sybrandb_at_yahoo.com>
Date: 16 Aug 2004 03:55:30 -0700
Message-ID: <a1d154f4.0408160255.10dab670@posting.google.com>

marjina98_at_hotmail.com wrote in message news:<24bfee06.0408152254.1e97f8b6_at_posting.google.com>...
> Hi,
>
> I have a following question:
>
> When using Windows with Oracle and stop the Oracle Instance using
> windows Services Start/Stop the Oracle Database is shutdown.
>
> What kind of shutdown is performed in this case ? (Normal, Immediate,
> Transactional or Abort )
>
> Thanks
>
> Marjina

The default from 8i onwards is immediate but this can be changed by changing the ora_shutdown_type registry value. It used to be abort in previous versions.

Sybrand Bakker
Senior Oracle DBA Received on Mon Aug 16 2004 - 05:55:30 CDT