Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: RE: How can I measure my DB performance.

RE: RE: How can I measure my DB performance.

From: Matthew Zito <mzito_at_gridapp.com>
Date: Fri, 29 Aug 2003 09:14:27 -0800
Message-ID: <F001.005CDFFD.20030829091427@fatcity.com>

Well, unlike BogoMips, which is just kind a mostly meaningless number the kernel generates on boot, a TPC benchmark is a measurement of the performance of a specific database on a specific platform - not the measure of your database. The database is provided to you, and you're very limited as to what you can tweak. So, for benchmarking SQL Server vs. Oracle, say - its a reasonably valid comparison. But for benchmarking your financial db on linux vs sun, for example, its totally inappropriate.

Thanks,
Matt

--
Matthew Zito
GridApp Systems
Email: mzito_at_gridapp.com
Cell: 646-220-3551
Phone: 212-358-8211 x 359
http://www.gridapp.com


> -----Original Message-----
> From: ml-errors_at_fatcity.com [mailto:ml-errors_at_fatcity.com] On
> Behalf Of Stephane Faroult
> Sent: Friday, August 29, 2003 12:50 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: RE: How can I measure my DB performance.
>
>
> http://www.tpc.org
>
> >
> >Jake
> > Compare to what? Another database? To what its
> >performance should be?
> >
> >Dennis Williams
> >DBA, 80%OCP, 100% DBA
> >Lifetouch, Inc.
> >dwilliams_at_lifetouch.com
> >
> >
> >-----Original Message-----
> >Sent: Thursday, August 28, 2003 6:59 PM
> >To: Multiple recipients of list ORACLE-L
> >
> >
> >Is there a standard query I can run to compare the
> >performance of a db.
> >(Kind of like bogomips for unix)
> >
> >Thanks,
> >Jake Johnson
> >jake_at_plutoid.com
> >
> >Plutoid - http://www.plutoid.com - Shop Plutoid for
> >the best prices on
> >Rims, Tires, and Wheel Packages.
> >
> >
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Stephane Faroult
> INET: sfaroult_at_oriolecorp.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> 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.net -- Author: Matthew Zito INET: mzito_at_gridapp.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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 Aug 29 2003 - 12:14:27 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US