RE: DBA Checklist

Well, this code was untested.

Jared

On Mon, 26 Jun 2000, Afanassiev, Alex wrote:

> Hi Jared
>
> I found a bug in your code: :)
>
> before you send handling to the store you should close the fridge to make
> sure that the beer stays cold
>
> also I would prefer to take 'remove beer' and 'drink beer' statement out of
> the IF condition as in my opinion they should be executed in any case
>
> Here is my version:
>
> loop
>
> goto fridge
>
> open door
>
> if ! fridge_full_of_beer
> close door
> goto store
> buy more beer
> open door
> fill fridge
> end if
>
> remove beer
> drink beer
>
> goto top of loop
>
>
> :)
>
> With regards
> Alex Afanassiev
> Oracle DBA, TOC Operations Support/IDO
> Tel: (03) 8 661 20 61
> Fax: (03) 9 650 36 74
>
>
> > -----Original Message-----
> > From: Jared Still [SMTP:jkstill_at_bcbso.com]
> > Sent: Tuesday, June 27, 2000 11:26 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Re: DBA Checklist
> >
> >
> > One of the most important things to monitor is the
> > quantity and quality of the beer in the fridge.
> >
> > DBA's have been known to make heavy use of this
> > tool to make it through the a weekend of
> > oncall activity.
> >
> > Pseudo code: ( recode in your favorite language )
> >
> > loop
> >
> > goto fridge
> >
> > open door
> >
> > if ! fridge_full_of_beer
> > goto store
> > buy more beer
> > fill fridge
> > else
> > remove beer
> > drink beer
> > end if
> >
> > goto top of loop
> >
> > This can be run as a background task, providing
> > you have a notebook computer with a wireless LAN
> > connection and some of the less important tools
> > in the standard DBA collection.
> >
> > Among the *important* tools in the collection:
> >
> > Red Hook
> > Deschutes Brewery
> > McMenamin's
> > Filson (sp? )
> > Dos Equis
> > Tres Equis ( this will stimulate you during a late night session )
> > Bridgeport Brewery
> > Guinness
> > ...
> >
> > There are other inconsequential tools in the DBA's
> > toolbox that we need not bother with here.
> >
> > Jared
> >
> >
> >
> >
> > On Mon, 26 Jun 2000 mleith_at_bradmark.co.uk wrote:
> >
> > > Guys,
> > >
> > > I know this has been covered before, but I cleared out my archive, and
> > now have no listing of it. I would be interested in getting your feedback
> > as to the tasks a DBA should have to perform on a daily/weekly/monthly
> > basis. Things that should be monitore
> > d in background, or checked hourly etc. etc.
> > >
> > > Do any of you have schedules that you follow daily? It is a bit of a
> > wide and varied question I know, and a lot of you do have varied task to
> > perform depending on your roles. The aspect I am looking in from is on a
> > Production DBA side.
> > >
> > > Any insight is greatly appreciated. I will put together a list of things
> > you guys feel should be monitored/managed and post it back to the
> > list/web.
> > >
> > > Thanks in Advance
> > >
> > > Mark
> > >
> > >
> > > --
> > > Author:
> > > INET: mleith_at_bradmark.co.uk
> > >
> > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > > San Diego, California -- Public Internet access / Mailing Lists
> > > --------------------------------------------------------------------
> > > 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).
> > >
> >
> >
> > Jared Still
> > Certified Oracle DBA and Part Time Perl Evangelist ;-)
> > Regence BlueCross BlueShield of Oregon
> > jkstill_at_bcbso.com - Work - preferred address
> > jkstill_at_teleport.com - private
> >
> >
> > --
> > Author: Jared Still
> > INET: jkstill_at_bcbso.com
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > 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).
> --
> Author: Afanassiev, Alex
> INET: Alex.Afanassiev_at_team.telstra.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> 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).
>
>
>

Jared Still Received on Tue Jun 27 2000 - 17:30:16 CDT