Oracle-L: RE: dbshut script - why shutdown so much???

From: Jesse, Rich <Rich.Jesse_at_qtiworld.com>
Date: Fri, 04 Apr 2003 07:08:50 -0800
Message-ID: <F001.0057A5C9.20030404070850@fatcity.com>

Oh joy! The ABORT argument again! ;)

Is there a way to flush table monitoring counts before the ABORT, either in 8i or 9i?

Rich

Rich Jesse                        System/Database Administrator
rich.jesse_at_qtiworld.com           Quad/Tech International, Sussex, WI USA

-----Original Message-----
Sent: Thursday, April 03, 2003 8:59 PM
To: Multiple recipients of list ORACLE-L

All this discussion on shutdown does motivate me to ask why is everyone shutting down so frequently?

Almost without exception my ideal for any oracle database is

never shut it down
if you really do need to shut it down, then use abort
if you are not allowed to use abort, then use abort-startup-shutdown

Justification for (a):
Ever looked inside the buffer cache, library cache etc. Its the most complicated gobbledeegook you'll ever see...Very smart people with very little social skills probably wrote the code for that stuff...And who pays for those smart people? We do, in license fees. Shutting your db is like saying "Hey, I love paying that monster license, but I'm not planning on getting any of the benefits". Its like the classic "We shut down during quiet time"...In just about every db I've seen, the definition of "quiet" time (eg Sunday night) is the time just before the really busy time (eg Monday morning). So by shutting down, you get the least benefit from the various cache's when you need it most.

Justification for (b):
Worrying about abort is tantamount to having no confidence in your database to cope with power outages. If you are that low in your confidence of Oracle, then you would have never chosen the product in the first place.

Justification for (c):
There *are* some times when abort is not appropriate. Anything the might change the fundamental structure/usage of your redo logs is the key thing here. With 9i, there appears to be more and more ways of doing this (supplemental logging, log_parallelism), so a little care is required.

Cheers
Connor
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Jesse, Rich
INET: Rich.Jesse_at_qtiworld.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Fri Apr 04 2003 - 09:08:50 CST