Chinaunix

标题: Oracle说其实ADDM可以不用EM的 [打印本页]

作者: jiangxiaoyu 时间: 2011-12-19 13:56
标题: Oracle说其实ADDM可以不用EM的

其实ADDM可以不用EM的,本人一直以为ADDM需要EM的呢。

其实请看 metalink上ID 276103.1的文章，以下是节选，作为AWR的辅助还是不错的。

$ORACLE_HOME/rdbms/admin/addmrpt.sql

The following is an excerpt of an ADDM report:

FINDING 1: 28% impact (97 seconds)
----------------------------------
Individual database segments responsible for significant user I/O wait were found.

   RECOMMENDATION 1: Segment Tuning, 28% benefit (97 seconds)
      ACTION: Run "Segment Advisor" on TABLE "SCOTT.T" with object id 51924.
         RELEVANT OBJECT: database object with id 51924
      ACTION: Investigate application logic involving I/O on TABLE "SCOTT.T" with object id

。。。

欢迎光临 Chinaunix (http://bbs.chinaunix.net/)