| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: On the question of "What is a Large Database Anyway ?"
Thanks for letting me know of this . I am afraid I have not had a chance to investigate the man or his book ..... but it looks like I am going to have to.
-----Original Message-----
To: Multiple recipients of list ORACLE-L
Sent: 6/1/01 8:00 PM
Wow... that's good to know.. Gaja's a really nice guy, and I will tell him you liked his talk.
If anyone wants to learn more about his ideas.. There are a couple of white papers on the Quest website...
http://www.quest.com/shareplex/ <http://www.quest.com/shareplex/>
On the left hand side, click on the 'white papers' link. There are a couple by Gaja, and Steven Feuerstein (PL/SQL guru), Eyal Aronoff, and even Kevin Loney.
Some even talk about maintaining and working in a 'large' environment.
pretty interesting reading...
Nick Wagner
-----Original Message-----
Sent: Friday, June 01, 2001 5:06 PM
To: Multiple recipients of list ORACLE-L
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
<http://www.amazon.com/exec/obidos/ASIN/0072131454/o/qid=991436418/sr=2-
1/ref>
=aps_sr_b_1_1/002-4814740-2092864
-----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
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com <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 ListsReceived on Sat Jun 02 2001 - 00:00:54 CDT
--------------------------------------------------------------------
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: Kevin Lange INET: kgel_at_ppoone.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).
 |
 |