I'll agree to that. I've had many discussions with our SAP BASIS admin about this. They have to shutdown SAP periodically, and she was always asking to bounce the database.
I always ask 'Why?', and would proceed to explain why not. She finally quit asking. ;) Jared On Thursday 03 April 2003 18:58, Connor McDonald wrote: > 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 > > a) never shut it down > b) if you really do need to shut it down, then use > abort > c) 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 > > --- Chris Berry <[EMAIL PROTECTED]> wrote: > >From: > Joan Hsieh <[EMAIL PROTECTED]> > > > >Chris, > > >We hang on shutdown immediate, not startup. That's > > > > why I choose to use > > > > >shutdown abort. > > > > Well, in that case of course you'd use it, but > > personally, if it was me, I'd > > want to find out why it was hanging, and fix that > > instead. I'm not > > suggesting shutdown abort never be used, I'm just > > saying use the right tool > > for the right job when you have a choice. > > > > Chris Berry > > [EMAIL PROTECTED] > > Systems Administrator > > JM Associates > > > > "Without change, something sleeps inside us, and > > seldom awakens. The > > sleeper must awaken." -- Duke Leto Atreides > > _________________________________________________________________ > > > Protect your PC - get McAfee.com VirusScan Online > > http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 > > > -- > > Please see the official ORACLE-L FAQ: > > http://www.orafaq.net > > -- > > Author: Chris Berry > > INET: [EMAIL PROTECTED] > > > > 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: [EMAIL PROTECTED] (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). > > ===== > Connor McDonald > web: http://www.oracledba.co.uk > web: http://www.oaktable.net > email: [EMAIL PROTECTED] > > "GIVE a man a fish and he will eat for a day. But TEACH him how to fish, > and...he will sit in a boat and drink beer all day" > > __________________________________________________ > Yahoo! Plus > For a better Internet experience > http://www.yahoo.co.uk/btoffer -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).