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@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
>


Other related posts: