In its broadest sense, learning can be defined as a process of
progressive change from ignorance to knowledge,
and from indifference to understanding....
How to Identify Resource Intensive SQL for Tuning收藏
上一篇 /
下一篇 2008-04-04 00:07:17
/ 个人分类：Note
| Subject: | How to Identify Resource Intensive SQL for Tuning |
| | Doc ID: | Note:232443.1 | Type: | TROUBLESHOOTING |
| | Last Revision Date: | 20-AUG-2006 | Status: | PUBLISHED |
PURPOSE
This article provides guidance on how to identify the most resource intensive SQL statements in a database for tuning purposes.SCOPE & APPLICATION
The techniques described here can be used when initial diagnosis of a database performance problem suggests that further investigation needs to concentrate on finding and tuning the most resource intensive SQL statements according to specific criteria, e.g.- using the most CPU
- performing the most disk I/O operations
- having the most executions
- taking the longest time to execute (elapsed time)
The article should be of use to Database Administrators, Support Engineers, Consultants and Database Performance Analysts.
导入论坛
引用链接
收藏
分享给好友
推荐到圈子
管理
举报
TAG:
