The treasure hidden in Oracle: STATSPACK

As part of Oracle's smart infrastructure, Oracle's 10 Gb automatic load database can work with the automatic database diagnostic monitor to help database administrators diagnose and fix performance problems. In the description of smart infrastructure, we can see the following:

Automatic Load Database

Automatic maintenance task

Server alarms

Consultant tool framework

The automatic load database (AWR) is like STATSPACK. In short, it is a collection statistics warehouse. Based on the automatic maintenance task, we can know the working status of the database after work: collect statistics. With server alerts, you have the ability to create alerts and thresholds for a variety of interesting options. The Advisor tool framework is where we find all the consultants, such as SQL optimization consultants and SQL access consultants.

So when AWR is available and automatic database diagnosis and monitoring (ADDM) is added, We can do everything that is easy to manage databases. Why should we use STATSPACK again? In terms of time and money, I think it is worth trying to use STATSPACK again. I will start with money.

Cause 1: Money

As in previous articles, using repositories and packages (fine-tuning and diagnostics, such as adjusting packaging and diagnostic packages) must be licensed. These packages act as the main interface of AWR, although AWR information can be accessed through its provided SQL script. If your licensing benchmark is 300 users, your licensing feature must have a matched cost benchmark. In this example, you basically have to pay the 300 "Xi" Tuning package. Even in reality, only a few users (for example, database administrators) will be actual users.

There is no doubt that the cost is expensive, but some pain points can be reduced by the number of permissions you have. The more licenses you have, the more discount you get. The initial payment price is a small part, because you have to pay for two elements: Basic authorization fee and 22% maintenance fee. Looking forward to the future, you only need to pay the annual maintenance fee in the future, so that you can get your customer number so that you can access My Oracle Support (New Metalink name ). If you have questions about the authorization model, I assure you that this is an accurate description of the actual situation. However, your actual cost will be the number between your quotation and your sales representative. If you want to use features like AWR but are not willing to pay tens of thousands of yuan, what is your option (this probably does not include using third-party tools, such as Oracle's Toad, now it includes an alert message about the license feature, which is used by Toad to display its interface )? In the future, the closest to AWR is STATSPACK.

Cause 2: Time

I want to extend the time meaning of this situation. This time is related to your work time. If you started from a few years ago and used 10 Gbit/s, but now you are looking for new job opportunities, and the new job uses not only 10 Gbit/s, earlier versions such as 9i? It is unlikely to fall into 9i. What do you think? Many of the 11i families run on 9.2.0.5 or 6. STATSPACK. E-Commerce Suite databases such as AWR are your only choice. In addition, Oracle8i (8.1.7 in the age) is still in use, although not as popular as in the past few years.

Time also involves the evolution of manageability. I am not saying that you must be an UTLBSTAT/UTLESTAT odd to understand the functions provided by AWR, but it is of course not unreasonable from STATSPACK. If you can understand how to read and interpret the ADDM report (basic information of AWR), then learn how to use the AWR-based report to do the same thing and make it much easier.

1 2 Next Page