Re: Veritas Quick I/0 and Oracle/ Asycnchronous I/O

I disagree wholeheartedly with this statement Alex. How can you make this statement without knowing the situation? (You seem to be becoming the resident troller in this group! Sorry, but it does appear that way.)

In spite of all evidence and repeated warnings, management often does not allow the most reasonable "solution" - preferring instead to play ostrich and simply throw hardware at the problem. Then one day even this isn't enough or it becomes prohibitively expensive and they want to hold someone else responsible for their own bad decisions - and the all too common scapegoat hunting expedition begins! That is when I usually forward to the "hunters" the same email that I sent them three years ago (and two years ago and a year ago , and six months ago, ...) analyzing the problem and proposing a reasonable solution - with attached proof (e.g. tkprof output showing how rewriting a few problematic queries can reduce CPU utilization by a factor of 72 and LIO by a factor of 6200! A real life example - that stayed like this for over three and a hlf years!).

-Don Granaman
[certifiable OraSaurus]

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Monday, June 11, 2001 1:40 PM

> Of cource you did not do your job properly. Or are you telling us that
> damagement did not do their job properly? I have never heard anything more
> ridiculous. :-).
>
> Alex Hillman
>
> -----Original Message-----
> Sent: Monday, June 11, 2001 8:50 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Jared wrote:
>
> >I just *had* to point this out. Had too many damagers want to solve
> >everything by buying HW when they have no idea what the problem is.
> >
>
> how about Sun E650, 26 CPUs (yes, I said 26), 9GB RAM
>
> made the application fly. Until we hit THE ultimate peak stress day and
> they died. I had spent the year prior screaming about how the application
> needed some serious rewrite or we would die on that day. Database had been
> "designed" (if you can call it that) by people who did not know Oracle and
> so recreated their flat file system.
>
> They told me that the reason we died was because I had not done my job
> properly.
>
> What's wrong with that picture?
>
>
> _________________________________________________________________
> Get your FREE download of MSN Explorer at http://explorer.msn.com
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.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).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Hillman, Alex
> INET: Alex.Hillman_at_usmint.treas.gov
>
> 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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Don Granaman
  INET: granaman_at_home.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).