Re: "Performance Counters"
- From: "Sandra Becker" <sbecker6925@xxxxxxxxx>
- To: "Oracle-L Freelists" <Oracle-L@xxxxxxxxxxxxx>
- Date: Fri, 27 Apr 2007 12:00:55 -0600
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@xxxxxxxxx> 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@xxxxxxxxxxxxxx> wrote: > > I have one answer…. Response time. > > > > It sounds like you are getting yourself into a mess. > ------------------------------ > > *From:* oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] > *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 >