Re: shutdown immediate

From: Robert Klute <robert.klute_at_usa.net>
Date: Sat, 12 Feb 2000 02:18:48 -0800
Message-ID: <IjKlOOgSAPAXian3WML0DPkNkQ2V@4ax.com>

On Fri, 11 Feb 2000 19:18:33 +0100, "Dimm" <Dimm_at_kataweb.it> wrote:

>hi all,
>
>A short time ago I realize that for to do the shutdown immediate of the
>database
>I spend very very time waiting. (about 2 minutes)
>
>This also when There isn't users connect to the database. Why ???

The Steps in shutting a database are:

Normal
1 Lock out access to the Database
2 Wait until all users exit
3 ...
4 Flush DB buffers & redo log caches
5 Drop file locks
6 Complete ongoing transactions
7 Update file Headers
8 Drop Database instance lock
9 Synchronize control and DB files

Immediate
1 Same
2 Disconnect all users
3 Rollback all uncommitted transactions 4 - 9 Same

Abort
Do Steps 1, 5, 8. Done.

---
Robert Klute
Hewlett-Packard Performance Program
robert_klute_at_hp.com
(These postings are mine, not HP's) Received on Sat Feb 12 2000 - 04:18:48 CST