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

From: Kevin Lange <kgel_at_ppoone.com>
Date: Fri, 01 Jun 2001 15:35:07 -0700
Message-ID: <F001.00318E80.20010601153510@fatcity.com>

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

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). Received on Fri Jun 01 2001 - 17:35:07 CDT