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

。。。