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: "Performance Counters"

Re: "Performance Counters"

From: Jeffery Thomas <jeffthomas24_at_gmail.com>
Date: Fri, 27 Apr 2007 12:54:50 -0400
Message-ID: <22131320704270954w56347adfnd0713860f14fa4b1@mail.gmail.com>


Thanks for the replies. I like Mark's analogy -- measuring for engine RPM without knowing if we are even going in the right direction. Totally apt.

On 4/27/07, Ted Coyle <Ted.Coyle_at_medecision.com> wrote:
>
> I have one answer…. Response time.
>
>
>
> It sounds like you are getting yourself into a mess.
> ------------------------------
>
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *Jeffery Thomas
> *Sent:* Friday, April 27, 2007 11:02 AM
> *To:* Oracle-L Freelists
> *Subject:* "Performance Counters"
>
>
>
> We have a SQL Server team going to manage a new vendor-built application
> on 10g RAC (Solaris).
> They have zero experience with Oracle. They are asking the Oracle team
> for 'performance counters'
> similar to what they use with SQL Server so that they can identify
> "satisfactory performance criteria" to be
> used as non-functional requirements for the vendor building the
> application.
>
> The ones identified for SQL Server were:
>
> SQL Server: SQL Statistics: SQL Compilations/Sec counter must not exceed
> 100 per second over a 2 minute period.
> Average Disk Queue Length, averaged over a 2 minute period must not exceed
> 2.5
> SQL Server: Buffer Cache Hit Ratio should exceed 90% measured over a 2
> minute period.
> The CPU usage must not exceed 35% averaged over a 2 minute period.
> The SQLServer:LockWaitTime must not exceed 2ms measured over a 2 minute
> period
>
> If you've got a vendor building an application for you -- what kind of
> benchmarks -- if any -- actually make sense with
> respect to performance criteria that the vendor must meet?
>
> Thanks,
> Jeff
>
> No virus found in this incoming message.
> Checked by AVG Free Edition.
> Version: 7.5.467 / Virus Database: 269.6.1/777 - Release Date: 4/26/2007
> 3:23 PM
>
>
>
>
> _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
>
> The information transmitted is intended only for the person or entity to
> which it is addressed and may contain confidential and/or privileged
> material. Any review, retransmission, dissemination or other use of, or
> taking of any action in reliance upon, this information by persons or
> entities other than the intended recipient is prohibited. If you received
> this message in error, please contact the sender and delete the material
> from any computer.
>
>
> No virus found in this outgoing message.
> Checked by AVG Free Edition.
> Version: 7.5.467 / Virus Database: 269.6.1/777 - Release Date: 4/26/2007
> 3:23 PM
>

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Apr 27 2007 - 11:54:50 CDT

Original text of this message

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