Re[2]: DBA Checklist

Jared, if you are looking for code testers, I'd like to volunteer!

J> Well, this code was untested.

J> Jared

J> 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).
>>
>>
>>

J> Jared Still
J> Certified Oracle DBA and Part Time Perl Evangelist ;-) Received on Tue Jun 27 2000 - 18:22:37 CDT