Re: On the question of "What is a Large Database Anyway ?"

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: epost_at_kcc.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).

--
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: mno_at_MiracleAS.dk

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