![]() ![]() If you have questions about the licensing model, I assure you this is an accurate description of what takes place. Going forward, you then (only) have the annual maintenance and support fee, which is also what pays for your CSI number so you can access My Oracle Support (the new name for MetaLink). The initial price you pay is the one that cuts the deepest because you have to pay for two elements: the basic license and the 22% maintenance fees. The more you license, the better discount rate you get. This cost, no doubt, can be expensive, but some of the pain is reduced through volume. In this example, you would essentially pay for 300 seats of the Tuning Pack, even though in reality, a small handful of users (e.g., DBAs) would be the actual users. If your license metric is based on 300 named users, then your licensing of a feature has a matching cost basis. The packs serve as the main interface into the AWR, although information in the AWR can be accessed via supplied SQL scripts. ![]() Case I - MoneyĪs mentioned in past articles, use of the repository and any of the packs (tuning and diagnostics, as in tuning pack and diagnostics pack) must be licensed. So why re-visit STATSPACK when AWR, combined with ADDM, gets all the attention with respect to improving the manageability of a database? The main reasons why I feel it is noteworthy has to do time and money. The Advisor Framework is where we find all of the advisors, such as the SQL Tuning Advisor, SQL Access Advisor. For server-generated alerts, you have the ability to set warning and threshold values for numerous items of interest. Under automatic maintenance tasks, we have what Oracle does after dark: gather statistics. The AWR is most closely aligned with what STATSPACK is in terms of being a repository for collecting statistics. Under the Intelligent Infrastructure, we see the following components: ![]() Oracle 10 gs Automatic Workload Repository, as part of Oracles Intelligence Infrastructure, works hand in hand with the Automatic Database Diagnostic Monitor to help you, the DBA, diagnose and remedy performance problems. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |