Re: Cannot shutdown database normal!!!

From: Jens Kieffer-Olsen <dstdba_at_post4.tele.dk>
Date: Thu, 25 Mar 1999 15:25:15 +0100
Message-ID: <cOrK2.178$2n.379@news.get2net.dk>

Sean Leahy wrote in message ...
>
>
>I had the same problem. My issue was that SMON was busy cleaning up =
temp
>extents, which is part of the normal shutdown operation. It took 12 =
hours,
>but it shut down. I had to tune my temp segments and Sort Areas =
better.
>See if you have any temp objects in you temp tablespaces.

It's advisable to use a large NEXT extent size for the temporary = tablespace,
1MB or even the sort_area_size. Also run an alter tablespace ... = coalesce
at regular intervals.

--
Jens Kieffer-Olsen Received on Thu Mar 25 1999 - 08:25:15 CST