I understand the Oracle Diagnostics
- Hua Chun chun http://blog.csdn.net/metababy
Oracle diagnostics package Oracle database product is part of the collection, which provides for the administrator to diagnose and monitor the performance of automatic features that can make planning for the Oracle environment.
Oracle diagnostics package as a business manager of the expansion, it will help the DBA have an effective monitoring, diagnosis, planning and Oracle database environment.
It introduced the first automatic performance diagnosis, diagnostic performance of the slow system is a common task. I often need to make such a task. Although able to find a lot of tools to help solve the service, but rarely directly addressing issues such as: "how the system more slowly than last month?".
Because these tools are basically to provide some graphical display, but the statistical information system will be a way for them. Does not automatically advanced logic analysis.
Almost entirely my own mind to make such a cumbersome, repetitive, almost no innovation to speak of the analysis, the diagnosis of the completion of the mission is almost no help, I will only headache.
Oracle 11g, etc. I solved the problem of headache, which provides a diagnosis of bovine X package, this package are super. You can feel from the industry's most advanced technology.
Oracle has a built-in diagnostic package in Oracle's core database of self-diagnostic engine, known as automatic database diagnostic procedures to monitor (ADDM). This is a revolutionary tool for the industry's first to carry out self-diagnosis.
ADDM help me achieve on a regular basis check the database, automatic database to identify potential performance bottlenecks, but also remarkable is that it can actually provide some recommendations to correct these problems, in general, has always effective. Of course, this is also combined with manual analysis of the inside, can not be taken of its recommendations. However, this does not affect it the most X cattle.
ADDM, why such a magical, I find the information that is the case on its description:
ADDM first focused on analyzing the data in the most time-consuming activities, and then advanced through the issue of classification tree to the next drilling to determine the root cause of the problem. ADDM can be found in the performance of the real reasons behind the problem, rather than merely report the symptoms of the problem, this is it far better than any other Oracle database performance management tool or utility one of the factors. ADDM used the issue of classification tree includes Oracle performance expert decades of experience in performance tuning, dedicated to the accurate diagnosis of the most common problems, such as CPU, I / O bottlenecks, poor connection, the memory is too small, resource-intensive The SQL statement, lock contention, and so on.
In addition, ADDM In fact, there is a behind-the-scenes heroes in helping it become a star, is the behind-the-scenes heroes AWR: In order to be able to ADDM accurate diagnosis of performance problems to learn more about the activities of database and data
Treasury's load. Oracle 11g diagnosis in each package Oracle 11g database contains a built-in database of information, known as automatic load information base (AWR), the database contains information on the operation of the database statistics and other relevant information. Interestingly, ADDM also has a behind-the-scenes heroes --- AWR is a key component activities of the conversation history (that is, ASH). ASH every second of conversation all the activities of the current state of samples, and then stored in the memory. In this regard, we do not make in-depth study of friends who are interested can access Oracle official documents.
This data also shows that "Oracle Real Application Clusters (RAC) environment, ADDM for a cluster analysis of the performance of the particular model," but I was not used in such an environment, I believe there should be a fairly good performance . I believe that Oracle has always been the X image of the cattle.
My job is often mentioned earlier diagnosis and optimization, and the other is a monitor. Oracle has provided us with a smoothly. It automatically checks the different components, storage of a number of important historical information, the system provides us with acts of long-term view.
As a result, it can automatically complete these actions, I can easily browse through the Enterprise Manager to find out whether or not to achieve the desired goal. If not, only need to click the Mouse, will be able to plan and to provide parking and parking-related accidents Details.
In addition, it also allowed under the hand drill, in order to find the cause of the problem, my favorite track problems, there is a sense of accomplishment. From the general performance of the database page will be able to see at a glance the CPU, memory, as well as user activity and throughput of the three categories of information, it is very convenient for me, and so the database administrator. There are a number of properties page link, they can quickly access a chart, the chart can be displayed in accordance with the different dimensions of the most resource-intensive activities ( "Top Activity", "TopConsumers"), examples of activities, as well as a summary of the information database of information locked.
More good news is that Oracle Package 11g diagnosis of these powerful surveillance functions can also be used for 9i and 10g versions.
Finally, I would like to introduce one of the characteristics: high-level event notification
I personally think that nothing can be studied through e-mail, SNMP traps, as well as running custom scripts or PL / SQL course, and so on a different mechanism to send notice. Its senior embodiment of the many options available to configure some cases, the application. System to avoid the high overhead and false positives.
Text of the above is just my concern and a little more familiar aspects of the description, if you want a more in-depth study and understanding of, and Oracle, on its own or on the Oracle site inspection.
When we look back at what Oracle diagnosis of the main characteristics of packages, which include: Automatic Database Diagnostic Monitor-ADDM, automatic load information base-AWR, performance monitoring, the activities of the conversation history-ASH, high-level event notification.
Diagnostic kits and Oracle to optimize the performance package, the package configuration management, supply package, change management package, such as the use of synergies, but also to reduce the database management and maintenance burden. So that technicians can pay more attention to the needs of our minds.
As for the other, if you do not think I wrote that, because I have not used or rarely used, and not described. So as not to mislead viewers ^ _ ^
