Discover vmware optimization tool, include the articles, news, trends, analysis and practical advice about vmware optimization tool on alibabacloud.com
, as a step by steps:@?/rdbms/admin/awrrpt.sqlAnother approach is to call Oralce's package directly, which is suitable for scenarios where you write your own initiative to get a script tool, such as the following:Set pagesize 0
set linesize 121
spool d:\awr_commit_frequently.html
Select output from table (dbms_workload _repository.awr_report_html (977587123,1,1920,1921));
Spool off
Note:
dbms_workload_repository. Awr_report_html (
l_dbid in n
I took over an optimization project in the previous section, which requires that the company optimize the indexes of more than existing tables to improve the existing ones and eliminate invalid indexes. In view of the serious shortage of manpower (the resources of two and a half persons were counted at that time), the idea of Manually changing databases one by one was dispelled. The current program structure does not allow revolutionary practices, but
Like Yahoo's YSlow, Google's Open source Web site Optimization Tool page Speed is a firebug based Firefox plug-in, and, like YSlow, page Speed can help users improve the performance of their web site. After running it, you can see a list of suggestions to help your Web site load faster, and it will check your site against each item in the list and indicate if it's passed.
Page speed analyzes some Web serve
can be followed by parameters: All or cpu,block io,page faults and so on.You can also query directly in the Information_schema.profiling database table:Select State,sum (Duration) as Total_r,round (100*sum (Duration)/(select SUM (duration) from Information_ schema.profiling where [email protected]_id), 2) as Pct_r,count (*) as Calls,sum (duration)/count (*) as "R/call" from inform ation_schema.profiling where [email protected]_id GROUP BY state ORDER by Total_r desc;Finally, turn off set profi
Tags: blog ar sp div art C on logThe Awrdd is used for a comparison of two awr snapshots to achieve performance at different times of the year.Run the following statement for example to get AWRDD:@?/rdbms/admin/awrddrpt.sql2025 23 February 07:12 12026 23 February 12027 23 February All 12028 23 February 10:00am 12029 23 February 11:24 12030 23 February 12031 23 February 2014 11:26 12032 23 February 11:31 12033 23 February 11:31 12034 23 February 11:41
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.