Re: Size, what is it?

One of the guys that used to work for me in Premium Services, Martin Berg, once had this idea that you could measure the number of logical IO's (LIO's) per CPU per hour on a system. Scanning V$SQL and measuring the % of cpu time being used at the same time could give you an idea.

At least this will provide a unit of work that can be related to an Oracle database, although the idea has more buts and ifs than Denmark has rainy days. Whether you're doing OLTP or batch jobs, your unit would still be LIO's...

Steve Sapovits wrote:

> Sort of related, you might be interested in http://www.tpc.org
>
> ----
> Steve Sapovits
> Global Sports Interactive
> 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).

--
Venlig hilsen

Mogens Nørgaard

Technical Director
Miracle A/S, Denmark
Web: http://MiracleAS.dk
Mobile: +45 2527 7100


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mogens =?iso-8859-1?Q?N=F8rgaard?=
  INET: mno_at_MiracleAS.dk

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