Re: shutdown immediate takes forever

"Akinwande Seigmund Walter-Johnson III" <asjohns_at_midway.uchicago.edu> wrote in message news:<Kek97.48$N4.4293_at_news.uchicago.edu>...
> There is no one on the machine except me, , shutdown immediate takes forever
> but shutdown abort is fine

Other than rollback which most other people already raised in this thread, the other most common reason is SMON de-allocating Temp segments. With Oracle 8, SMON no longer deallocate extents at the end of each session. It does it at shutdown time. So your extents could build up if database is up for long time.

Since SMON only deallocates at the pace of 5 extents at a time, regardless of the size of extents, the smaller your extents are, the more extents are out there to be deallocated.

If can resolve this problem by creating large extents on Temp. Shutdown abort I believe opens the database first then de-allocate Temp. It still takes the same amount of time but at least you can use the database. You may get ST enqueue contention before the deallocation is done however.

Other than that, I have also seen Oracle hang at shutdown because of bug. Received on Tue Jul 31 2001 - 17:46:36 CDT