' automated optimization ' is just a gimmick to be able to automate the world and be quiet. It's just a name in the line. the most basic gripping system topsql, is through the awr, but there are many drawbacks and inflexible, such as the number of small, can not directly see the execution plan, sorting by the total time but will be a single slow leakage. for this I wrote a crawl script, which will generate HTML reports in the form of Web pages. can customize the crawl time period and the number of Topsql, directly hyperlink to the execution plan, the indicators more comprehensive than awrso mother no longer afraid I can not catch the SQL ~ ~later with the Plsql made an enhanced version:The interface mimics Awr's CSS style, and the execution plan's display also beautify the nextSQL text display formattingOracle Automatic optimization advice can be provided directly, people who do not understand the optimization technology can simply toss and tosssource code and Case test page:Http://files.cnblogs.com/kissdb/%E8%87%AA%E5%8A%A8%E5%8C%96%E4%BC%98%E5%8C%96%E8%84%9A%E6%9C%AC%28%E6%9D%8E%E5 %9d%a4%29.rar
Automated Topsql Optimization Scripts
