Method R)

Method R)

R indicates the response time ). The specific definition is as follows:

1. Target the tasks that are critical to the business.

2. Collect properly scoped, un-aggregated profile data for each task while the task is exhibiting the behavior you want to record.

3. React with the candidate repair that will have the greatest net payoff to the business.

A. Stop if the cost of the repair exceeds the cost of the problem ..

4. Go to step 1.

The core element here is that Profile. Profile provides a detailed description of the response time from the application to the end user. This layer is embodied in the Oracle database, namely the SQL Trace data to be extended.

Does it feel "virtual"? The R method is quite similar to some of our known database optimization methods, however, Cary Millsap claims that the R method is currently the best and most comprehensive Oracle optimization method. Let's take a look at some simple comparisons:

R method vs OWI Method

OWI (Oracle wait interface) is only a basic element of the R method. The R method is applicable to a wider range of diagnostic guidance policies (such as the Application layer) (see: How to Make an Application Easy to Diagnose );

R method vs YAPP

Interestingly, the YAPP (Yet Another Performance Profiling Method) Method process is as follows:

1. Obtain the service time and wait time and their components

2. Sort all components

3. Optimize each part in sequence

4. Reduce the cost or number of executions for each item in the table

Let's take a look at Descartes's methodology:

Never accept any truth that I do not know. That is to say, we should try to avoid reckless and prejudice. We can only make it clear and definite based on our own judgment. There is no truth to doubt.

The complex problems that can be studied can be divided into as many simple small problems as possible and solved separately.

Sort these small problems from simple to complex, and start with the problems that are easy to solve.

After all the problems are solved, check whether the problem is completely solved.

YAPP is actually a manifestation of Cartesian methodology.

YAPP is only applicable to the Oracle layer, and is powerless to the Web application layer. The R method is applicable to a wider range (in fact, it is an evolutionary version of YAPP). YAPP cannot determine the idle events of Oracle.

R method vs bottleneck analysis)

Bottleneck Analysis first needs to find the bottleneck. The R method is oriented to the target task and focuses on the business. Focus on the most important aspects.

 

Although it is not widely used yet, Method R is a perfect Method in theory. The ideas generated here are worth pondering.