Cary wrote the intro (and, along with Scott Gossett of Oracle University,
Craig Shallahamer and a few other "unknowns") did the tech-edit. I had the
privilege of doing the "developmental edit" (this means I got to help Gaja
make it fun and understandable for an entry-level tuner). But it also meant
I got to read it as Gaja and Kirti were writing it.... it's a wonderful book
and I believe it's actually out now.
>From: Mogens N�rgaard <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Re: On the question of "What is a Large Database Anyway ?"
>Date: Mon, 04 Jun 2001 00:01:18 -0800
>
>It's a good book. Cary Millsap has even written the intro :).
>
>Yep, Gaja will talk about using the wait-interface (available since 7.0.12)
>instead of all these stupid and mis-leading ratios flying around. That and
>Jonathan Lewis' book are the best I've seen since Dave Ensors Oracle8
>Design book, but that's kind of old now.
>
>For the original intro to the wait-interface (or time-based) tuning, you
>should of course read Anjo Kolks famous YAPP paper.
>
>"Post, Ethan" wrote:
>
> > I just got back from a little seminar from Quest with Gaja Krishna
> > Vaidyanatha and if he was dead (he's not that I'm aware of) he would be
> > rolling in his grave about your comments on hit rates and SGA sizes.
>His
> > new book 101 Oracle Performance Tuning will stress that you abandon
>those
> > hit rates and focus on V$SYSTEM_EVENT, V$SESSION_EVENT and
>V$SESSION_WAIT in
> > combination with CPU and IO stats. He states that Oracle is rather well
> > designed for physical IO. His presentation was great and I'm definatley
> > going to buy his book because I can learn something from this guy. So
>maybe
> > those small SGA's aren't so bad after all :)
> >
> >
>http://www.amazon.com/exec/obidos/ASIN/0072131454/o/qid=991436418/sr=2-1/ref
> > =aps_sr_b_1_1/002-4814740-2092864
> >
> > - Ethan Post
> >
> > -----Original Message-----
> > Sent: Friday, June 01, 2001 4:35 PM
> > To: Multiple recipients of list ORACLE-L
> >
> > As most everyone has said so far .... Its all subjective. What is
>large to
> > me .... is a dinky little thing to someone else.
> >
> > Right now at my current job we have around 37 instances on 4 mchines
>with 2
> > GB or less of memory and 2 - 4 processors each. These DBs range from a
>10
> > MB to a 70 MB SGA (yes, sounded real small to me when I got here also).
> > These databases are all in the realm of 60 - 100 GB of data each.
> >
> > My last job we had 2 machines running 4 instances. These DBs had SGAs
>from
> > 350 MB to 980 MB in size with 4 CPUs using 4 GB of memory. As far as
>size
> > goes, we had upwards of a Terrabyte of data.
> >
> > To me, I have found that I have to treat both setups the same. They
>really
> > do have the same problems (space, hit rates, drive failures, hardware
> > failures, etc.) You just have to pay closer attention to certain
>aspects of
> > them differently. With the small SGAs we have to look real close at hit
> > rates and all the Memory Dependent aspects of the DB. With the large
>amount
> > of data on the other DB we had to look more closely at Data and file
>related
> > problems.
> >
> > All I am trying to say is ......... its all subjective.
> >
> > Kevin
> >
> >
>------------------------------------------------------------------------------
> > This e-mail is intended for the use of the addressee(s) only and may
>contain privileged, confidential, or proprietary information that is exempt
>from disclosure under law. If you have received this message in error,
>please inform us promptly by reply e-mail, then delete the e-mail and
>destroy any printed copy. Thank you.
> >
> >
>==============================================================================
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Post, Ethan
> > INET: [EMAIL PROTECTED]
> >
> > 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: [EMAIL PROTECTED] (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).
>
>--
>Venlig hilsen
>
>Mogens N�rgaard
>
>Technical Director
>Miracle A/S, Denmark
>Web: http://MiracleAS.dk
>Mobile: +45 2527 7100
>
>
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Mogens =?iso-8859-1?Q?N=F8rgaard?=
> INET: [EMAIL PROTECTED]
>
>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: [EMAIL PROTECTED] (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 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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
