Re: Would you allow this?

Hi George,

I don't have a 'Dear Boss' from you on this topic, BUT, have your 'Dear Boss' about another current topic regarding: sys-admin's thinking all disks on few filesystems is a "rockin' good thing", so your note must be helpful to someone :-) I'm still in "screw" mode on this one...

I'd be happy to behold the library of all you're 'Dear Boss' notes :-) PLEASE Regards follows....
Suzy V.
Denver, CO, USA

> Dear Boss,
>
> Since the rehost to the new SA specified file systems we have had the
> occasional Oracle "out of async requests" errors from Oracle.
>
> This async I/O lets the database issue a write request to the OS and
> then carry on without waiting for the write to finish. With our new
> setup the database is writing faster that the 'rocking' file systems can
> cope with because everything is getting queued up.
>
> Investigation with Oracle produced a recommendation better distribution
> across devices is an answer, they also say that the performance impacts
> are unknown.
>
> This is because Oracle do not expect their software to run across two
> devices especially as they say you should use multiple devices in their
> documentation.
>
> I'd estimate that we are running at about 25% the bottlekeck and things
> can only get worse..
>
> *****************
> Executive summary
> *****************
> I *&^%$* TOLD YOU SO!

George.Brennan_at_warnermusic.com wrote:
>
> Anyone got a copy of the 'Dear Boss' mail I did some time ago?
>
> It might be usefull for Lisa
>
> regards
> George.
>
> > -----Original Message-----
> > From: "Roy Ferguson" <rferguso_at_level1.com>
> > [mailto:rferguso_at_level1.com]
> > Sent: Wednesday, June 14, 2000 4:31 PM
> > To: SMTP_at_INL002@Servers["Multiple recipients of list ORACLE-L"
> > <ORACLE-L_at_fatcity.com>]
> > Subject: RE: Would you allow this?
> >
> >
> >
> > Lisa,
> >
> > Hopefully you've been collecting these responses. If so,
> > maybe you could use
> > them as a case against doing it.
> >
> >
> >
> > >
> > > Lisa,
> > > NO WAY UNDER ANY SITUATION!
> > >
> > > That's my opinion.
> > >
> > > --- Rachel Carmichael <carmichr_at_hotmail.com> wrote:
> > > > Lisa,
> > > >
> > > > Get it in writing that you are objecting to doing this
> > and that they are
> > > >
> > > > insisting it be done this way.
> > > >
> > > > Not that it will stop the problems, but at least you can
> > push the blame
> > > > back
> > > > on the ones who deserve it when it "all falls down"...
> > and it will. And
> > > > they
> > > > will come after you for it.
> > > >
> > > > Rachel
> > > >
> > > >
> > > > >From: "Steve Orr" <sorr_at_arzoo.com>
> > > > >Reply-To: ORACLE-L_at_fatcity.com
> > > > >To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> > > > >Subject: RE: Would you allow this?
> > > > >Date: Tue, 13 Jun 2000 11:21:32 -0800
> > > > >
> > > > >Lisa,
> > > > > > I am concerned about it starting runaway queries and eating up
> > > > resources
> > > > >
> > > > >Definitely could create a headache. If you don't have a
> > choice in the
> > > > >matter
> > > > >then create a profile/user account just for them, set
> > > > resource_limit=true
> > > > >and setup some reasonable CPU limits, etc. If they bump
> > up against the
> > > > >limits then you can ask, "What's wrong with your software that it
> > > > consumes
> > > > >so much resource?"
> > > > >
> > > > >Then take two aspirin and call us in the morning.
> > > > >
> > > > >
> > > > >Steve Orr
> > > > >
> > > > >
> > > > >-----Original Message-----
> > > > >Beilstein
> > > > >Sent: Tuesday, June 13, 2000 11:46 AM
> > > > >To: Multiple recipients of list ORACLE-L
> > > > >
> > > > >
> > > > >Lisa,
> > > > >Your employer sounds like a complete moron. If I was
> > you, I would start
> > > > >looking for another job. One of these days (maybe now),
> > the database is
> > > > >going to be hosed and YOU will get the blame for it happening.
> > > > >
> > > > > >>> "Allin, Sean" <sallin_at_trimarine-usa.com> 06/13/00
> > 01:32PM >>>
> > > > >heartfelt sympathies
> > > > >
> > > > >-----Original Message-----
> > > > >Sent: Tuesday, June 13, 2000 9:55 AM
> > > > >To: Multiple recipients of list ORACLE-L
> > > > >
> > > > >
> > > > >How many of you would allow a vendor to come in and do a
> > demo on a
> > > > >PRODUCTION
> > > > >DATABASE?
> > > > >
> > > > >I am being overridden. I am being told to allow it, it's their
> > > > database
> > > > >and
> > > > >if
> > > > >they hose it (who knows what this thing is going to do?)
> > it's their
> > > > >problem.
> > > > >What? It's just a reporting tool, but STILL! I am
> > concerned about it
> > > > >starting
> > > > >runaway queries and eating up resources reserved for CUSTOMERS.
> > > > >
> > > > >Can you feel my headache all the way from
> > Minneapolis.... I should
> > > > just
> > > > >take
> > > > >the afternoon off.
> > > > >Lisa
> > > > >
> > > > >
> > > > >--
> > > > >Author:
> > > > > INET: Lisa_Koivu_at_gelco.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: Allin, Sean
> > > > > INET: sallin_at_trimarine-usa.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: William Beilstein
> > > > > INET: BeilstWH_at_obg.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: Steve Orr
> > > > > INET: sorr_at_arzoo.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).
> > > >
> > > >
> > ______________________________________________________________
> > __________
> > > > Get Your Private, Free E-mail from MSN Hotmail at
> > http://www.hotmail.com
> > > >
> > > > --
> > > > Author: Rachel Carmichael
> > > > INET: carmichr_at_hotmail.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).
> > >
> > >
> > > =====
> > > Rocky Welch
> > > Oracle DBA Consultant
> > >
> > > rockyw_99_at_yahoo.com
> > >
> > > __________________________________________________
> > > Do You Yahoo!?
> > > Yahoo! Photos -- now, 100 FREE prints!
> > > http://photos.yahoo.com
> > > --
> > > Author: Rocky Welch
> > > INET: rockyw_99_at_yahoo.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: Roy Ferguson
> > INET: rferguso_at_level1.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:
> INET: George.Brennan_at_warnermusic.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
Received on Thu Jun 15 2000 - 19:03:10 CDT