Services - Oracle Performance Problem Detection, Diagnosis, Analysis & Resolution
Our method of Oracle performance management utilizes the core principle - i.e.- Using "response time" as the one and only
metric to optimize performance impediments. This method is utilized for all types of Oracle databases including those
deployed in an Oracle Real Application Cluster (RAC) environment.We use the following well-known formula:
Response Time = Service Time + Wait Time
We believe in analyzing the "waits" within the Oracle database to determine the source of the true bottleneck. The salient idea
behind this approach is to reduce resource consumption and wastage. Thus reducing the waits, significantly increases our
ability to eliminate one or more bottlenecks for a given component of an application.
We use an industry-proven, repeatable and mathematical driven methodology to investigate, determine, and implement
"meaningful solutions" to real problems. And as part of our commitment to this method, we empower our customers by
training our customers to use this method.
We do not believe in the "laundry-list based" performance management technique, where absolutely meaningless numbers such
as database buffer cache-hit ratio, library cache-hit ratio, dictionary cache-hit ratio, latch hit-ratio and scores of other ratios are
checked in an effort to perform "diagnosis". We believe in solving real problems using response time, and not engage in
wild-goose chases!
Our method is based on mathematics not performance voodoo...It is reliable and repeatable!
Our method of Oracle performance management utilizes the core principle - i.e.- Using "response time" as the one and only
metric to optimize performance impediments. This method is utilized for all types of Oracle databases including those
deployed in an Oracle Real Application Cluster (RAC) environment.We use the following well-known formula:
Response Time = Service Time + Wait Time
We believe in analyzing the "waits" within the Oracle database to determine the source of the true bottleneck. The salient idea
behind this approach is to reduce resource consumption and wastage. Thus reducing the waits, significantly increases our
ability to eliminate one or more bottlenecks for a given component of an application.
We use an industry-proven, repeatable and mathematical driven methodology to investigate, determine, and implement
"meaningful solutions" to real problems. And as part of our commitment to this method, we empower our customers by
training our customers to use this method.
We do not believe in the "laundry-list based" performance management technique, where absolutely meaningless numbers such
as database buffer cache-hit ratio, library cache-hit ratio, dictionary cache-hit ratio, latch hit-ratio and scores of other ratios are
checked in an effort to perform "diagnosis". We believe in solving real problems using response time, and not engage in
wild-goose chases!
Our method is based on mathematics not performance voodoo...It is reliable and repeatable!
 |
| |
 |
| |
 |
| |
 |
| |
 |
| |
 |
| |
 |
| |
 |
| |
 |
DBPerfMan - In The Business of
Optimizing Oracle Database
Performance!
Optimizing Oracle Database
Performance!
| Copyright © 2004-2007 DBPerfMan, LLC. All rights reserved. |
All engagements are provided with a detailed "performance report" as a deliverable with the required "scientific and
mathematical proof" to corroborate any assertions, findings or conclusions.
mathematical proof" to corroborate any assertions, findings or conclusions.
