Size, what is it?

From: Dave Morgan <dave.morgan_at_cybersurf.net>
Date: Fri, 01 Jun 2001 10:25:39 -0700
Message-ID: <F001.003180F5.20010601094111@fatcity.com>

Hi All,

        Being able to lift my head from the problems at my new
        job finally. I would like to get some definitions of 
        what is a "large" database and the hardware that it is 
        running on. There are multiple different types of "large",
        transactions, physical size, number of objects, 
        number of connections, SGA size, etc. 

        My current database is a heavy transaction site but small in
        other respects.

        Oracle 8.1.7, 150GB physical size, 700MB SGA, 10 GB per day redo, 
        300-700 OLTP connections at any time all on a SUN E450, 2 CPU's, 4 GB
RAM,
        Baydel disk array (RAID 3). The machine is relativiely idle, 
        or I/O bound, memory starts becomming a limit above 700 connections.


        A previous large database was
        Oracle 8.0.5, 50 GB physical, associated with 4 TB of image files
        on the filesystem, 350 GB SGA, 2 GB per day redo, 100 DSS connections, 
        all on a SUN E5000, 6 CPU's 6 GB RAM, many hardware RAID arrays, 
        machine was CPU bound almost all the time.

        Most of the database I have seen have been on machines that are grossly
        over powered for the work that they do so I am hoping I can determine
        some figures for hardware vs workload based on real data.

        Your assistance would be appreciated. Please include as many details
        as possible including why you think it is a "large database" and
        machine utilization.

        Also, does anyone have experience with Baydel disk arrays. They seem
        to be a happening  setup even if they are hardwired RAID 3 :(

TIA
Dave         

--

Dave Morgan
DBA, Cybersurf
Office: 403 777 2000 ext 284
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Dave Morgan
  INET: dave.morgan_at_cybersurf.net

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 - 12:25:39 CDT