Re: db hang on shutdown

From: Ban Spam <ban-spam_at_operamail.com>
Date: Thu, 17 Jan 2002 02:05:31 GMT
Message-ID: <Xns9198B80AD565ESunnySD@24.0.3.73>

Ed_Stevens_at_nospam.noway.nohow (Ed Stevens) wrote in news:3c458467.155788762_at_ausnews.austin.ibm.com:

>>If you are desparate & have some "extra" disk space, you might want to
>>try to add a "BIG" (2GB) file to TEMP tablespace.
>>

> Help me out here.  What does having a very large TEMP tablespace do
> here? 
>

After I increased the size of my TEMP tablespace a DB which was taking 2 - 3 hours to shutdown would shutdown in 2 - 3 minutes. It has something to do with giving SMON enough free resources to quickly rollback an uncommitted transaction.

It is like giving chicken soup to a dead man. It can't hurt anything.
Who knows it just might help! Received on Wed Jan 16 2002 - 20:05:31 CST