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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).