Re: "Performance Counters"

Apparently, the replies were sent only to you. I would be interested in what was said. I have a developer constantly asking me about such things. I tell him you're comparing cheese and Wednesday, but it isn't soaking in. Perhaps I'm not explaining it well, or it could be a deliberate blind spot about Oracle.
Sandy

On 4/27/07, Jeffery Thomas <jeffthomas24_at_gmail.com> wrote:
>
> 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