Shulou(Shulou.com)06/03 Report--

First, who will optimize

Database administrator

Application architect

Application designer

Application developer

OS system administrator

Storage system administrator

What does DBA do in tuning

1) Application tuning (DBA works with developers)

SQL statement performance Change management

2) instance tuning (DBA is responsible)

MemoryDatabase structure Instance configuration

3) operating system (DBA works with system administrator)

I/O Swap Parameters

III. Tuning methodology

The full name of OWI is Oracle Wait Interface, which is a tuning method based on waiting events. The number of waiting events has grown to nearly 1000 by 11g. Starting with 10g, the focus of performance tuning is no longer simply on improving cache hit rates. OWI is a way to locate process bottlenecks (that is, wait events): including I latches O, locks, latches, bk process activities, network latencies, and so on. It records the number of times and the total wait time for all these events. Before OWI, to locate the problem, you had to execute all the projects on the checklist, and then judge the problem based on experience, which is often a waste of time and prone to errors. By removing or reducing the Wait Events, the working efficiency of the system can be directly improved. This data is recorded in dynamic views or AWR reports.

Oracle recommends using the OWI method to eliminate the problem directly by waiting for the analysis of the event.

The adjustment target has three characteristics:

1) specific (Specific)

2) measurable (Measurable)

3) realizable (Achievable)

The OWI methodology can be summed up as follows:

1) from top to bottom, grasp the principal contradiction

2) choose the events that can maximize the benefits.

3) quit as soon as the goal is reached

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.