Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: DBA Checklist

RE: DBA Checklist

From: Afanassiev, Alex <Alex.Afanassiev_at_team.telstra.com>
Date: Tue, 27 Jun 2000 10:48:38 +1000
Message-Id: <10540.110491@fatcity.com>


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
Received on Mon Jun 26 2000 - 19:48:38 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US