Re: Size, what is it?

Hi Mogens

        I agree with all your statements.

        What I am trying to figure out is what is it that streches the 
        machine. I was quite surprised to see an E450 doing 10GB of
        transaction logs per day. Pure OLTP using stored procs.

        I was hoping to get descriptions of the types and amounts of work 
        a "large" or "busy" database does along with the description of 
        the hardware that is being used. This would allow a baseline to
        be developed for estimating. 

        For example how much OLTP work can a Linux 2 CPU machine with
        lots of memory do? How many DSS users can a similar machine 
        support? I would also like to ask similar questions about other
        UNIX configurations? VAX/VMS would also be interesting.
        NT, someone else can do the work if they want :) 

        SUN is also now offering hardware RAID 3 in their RSM2000 array.
        As I mentioned the Baydel array beats RAID 5 easily, and is 
        substantially cheaper than an equivalent RAID 10 (1+0) array
        which is my preference. (and everyone elses :)

        Thanks for your input.

Dave

Mogens wrote ...

> My dear friend Cary Millsap once came up with a definition for a VLDB: It's any
> database that stretches its hardware.

> I cannot see any relationship between SGA and database sizes. None.

> RAID-3: Bit-level striping. Incredible it still exists (in my opinion) :).

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