Re: dbshut script - why shutdown so much???

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 <compjma_at_hotmail.com> wrote: > >From:
> Joan Hsieh <joan.hsieh_at_tufts.edu>
>
> > >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
> > compjma_at_hotmail.com
> > 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: compjma_at_hotmail.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).
>
> =====
> Connor McDonald
> web: http://www.oracledba.co.uk
> web: http://www.oaktable.net
> email: connor_mcdonald_at_yahoo.com
>
> "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: jkstill_at_cybcon.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).