admin管理员组文章数量:1593971
以下为一份addm报告,查看该报告,可以得到addm给我们的建议,addm和awr一样,每份addm报告的格式基本一样,只是内容不同而已。
$ cat addmrpt_1_20314_20317.txt
第一部分是指出收集ADDM的时间段
ADDM Report for Task 'TASK_62667'
---------------------------------
Analysis Period
---------------
AWR snapshot range from 20314 to 20317.
Time period starts at 24-DEC-13 09.00.01 AM
Time period ends at 24-DEC-13 11.06.35 AM
第二部分是库的基本信息,主要包括版本,dbid
Analysis Target
---------------
Database 'PMSESBDB' with DB ID 1256960331.
Database version 11.1.0.6.0.
ADDM performed an analysis of instance ESBP1, numbered 1 and hosted at
PMSEBPD1.
第三部分列出db_time
Activity During the Analysis Period
-----------------------------------
Total database time was 402 seconds.
The average number of active sessions was .05.
第四部分是ADDM给出的一个大概的统计建议
Summary of Findings
-------------------
Description Active Sessions Recommendations
Percent of Activity
------------------------------ ------------------- ---------------
1 Virtual Memory Paging .05 | 100 3
2 Top SQL by DB Time .02 | 37.8 5
3 Top SQL by "Cluster" Wait .01 | 16.51 5
4 Commits and Rollbacks 0 | 6.91 2
5 Buffer Busy 0 | 5.58 0
6 Interconnect Buffer Busy 0 | 4.49 1
7 Unusual "Other" Wait Event 0 | 4.01 1
8 PL/SQL Compilation 0 | 3.07 1
9 Hard Parse Due to Parse Errors 0 | 2.34 1
10 Session Connect and Disconnect 0 | 2.22 1
备注:这里由于库很闲,所以这里的百分比都不大,虚拟内存换页也才5%,topsql的dbtime为2%也不高。
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
第五部分是ADDM的详解建议
Findings and Recommendations
----------------------------
Finding 1: Virtual Memory Paging----------建议1:肯定要从第一项说起,这里第一个就是虚拟内存换页。
Impact is .05 active sessions, 100% of total activity.
------------------------------------------------------
Significant virtual memory paging was detected on the host operating system.
Recommendation 1: Host Configuration--这是给出的建议,让调整主机信息。
Estimated benefit is .05 active sessions, 100% of total activity.
-----------------------------------------------------------------
Action
Host operating system was experiencing significant paging but no
particular root cause could be detected. Investigate processes that do
not belong to this instance running on the host that are consuming
significant amount of virtual memory. Also consider adding more physical
memory to the host.
Recommendation 2: Database Configuration
Estimated benefit is .05 active sessions, 100% of total activity.
-----------------------------------------------------------------
Action
Consider enabling Automatic Shared Memory Management by setting the
parameter "sga_target" to control the amount of SGA consumed by this
instance.--让设置sga_target
Recommendation 3: Database Configuration
Estimated benefit is .05 active sessions, 100% of total activity.
-----------------------------------------------------------------
Action
Consider enabling Automatic PGA Memory Manage
版权声明:本文标题:oracle addm报告分析,ADDM报告分析 内容由热心网友自发贡献,该文观点仅代表作者本人, 转载请联系作者并注明出处:https://m.elefans.com/dongtai/1728178782a1148185.html, 本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容,一经查实,本站将立刻删除。
发表评论