Re: Shutdown taking days

On Fri, 17 Jul 1998 17:45:41 GMT, zoider_at_my-dejanews.com wrote:

>I've got a 5 Gb test database on an NT server running ver 8. For the last
>several weeks, when shutting down the system, I've done a shutdown immediate.
>Last night I did shutdown normal. It's been sitting there for 16 hours so far
>and I don't know if it's hung or if it's processing.
>
>I do know, I think, that my rollback segments were full as I got an error
>message that one of them has hit it's max extents. Does this have anything to
>do with it?
>
>Should I do shutdown normal on a regular basis?

You've probably got a user logged on somewhere. Shutdown normal will prevent new connections, but won't terminate existing ones. Shutdown immediate will terminate connections and rollback their transactions. I normally use shutdown immediate.

Unless you require 24x7 availability of the database, I'd bounce it regularly. I do some of mine as frequently as once a week. If you're platform is unix, you should regularly bounce that too (according to my sys. admin.).

        Chuck
--
Chuck Hamilton
chuckh_at_dvol.com

If at first you don't succeed, sky diving isn't for you. Received on Fri Jul 17 1998 - 13:22:04 CDT