Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Size, what is it?
Sort of related, you might be interested in http://www.tpc.org
Work Email: sapovitss_at_globalsports.com Home Email: steves_at_delanet.com Work Phone: 610-491-7087 Cell: 610-574-7706 Pager: 877-239-4003
> -----Original Message-----
> From: Dave Morgan [SMTP:dave.morgan_at_cybersurf.net]
> Sent: Monday, June 04, 2001 1:41 PM
> To: Multiple recipients of list ORACLE-L
> Subject: 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).
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve Sapovits INET: SapovitsS_at_globalsportsinc.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 Mon Jun 04 2001 - 14:03:35 CDT