Re: shutdown immediate takes forever

From: OracleMS <lostpwds_at_hotmail.com>
Date: 1 Aug 2001 16:36:11 -0700
Message-ID: <17742ed1.0108011536.4ded74ff@posting.google.com>

> 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.
>

I thought SMON deallocated temporary segments (in temporary tablespaces) only at startup, not shutdown .... Received on Wed Aug 01 2001 - 18:36:11 CDT