11g新特性:awr报表增强

11g在awr report方面，还是增加了一些吸引眼球的地方，比如增加了对OS等主机配置的报告，对于dba来讲，在接手一个新环境时,或做现场服务时，该报表将会简少一些额外的工作，比如报表中已经可以显示主机名，操作系统，CPU个数，物理内存等，最让人关注的还是增加了主机负载的一些情况，具体变化请看下文：

[@more@]

主机方面:
Host Name Platform CPUs Cores Sockets Memory(GB)
----------- ------------------ ---- ----- ------- ----------
log51 Linux IA (32-bit) 4 2 2 3.96

LOAD PROFILE:
Load Profile Per Second Per Trans Per Exec Per Call
~~~~~~~~~~~~ ----------- ---------- --------- --------
DB Time(s): 1.0 6.5 0.11 0.29
DB CPU(s): 1.0 6.4 0.11 0.29
Redo size: 1,059.2 6,813.2
Logical reads: 73,493.3 472,724.2
Block changes: 5.7 36.5
Physical reads: 73,465.3 472,544.3
Physical writes: 0.6 3.7
User calls: 3.4 22.1
Parses: 2.1 13.3
Hard parses: 0.0 0.0
W/A MB processed: 9,217.0 59,285.9
Logons: 0.0 0.1
Executes: 8.9 57.3
Rollbacks: 0.1 0.4
Transactions: 0.2

说明:在load profile section，增加了DB Time(s)，DB CPU(s)，W/A MB processed，Rollbacks等，当然也去掉了sorts的统计信息，如果想看memery sort与disk sort等情况，需要在Instance Efficiency Percentages部分来观察,Instance Efficiency Percentages section没有原化。

HOST CPU & LOAD AVG:
Host CPU (CPUs: 4 Cores: 2 Sockets: 2)
~~~~~~~~ Load Average
Begin End %User %System %WIO %Idle
--------- --------- --------- --------- --------- ---------
1.01 1.20 14.2 11.6 0.1 74.2

Instance CPU
~~~~~~~~~~~~
% of total CPU for Instance: 25.1
% of busy CPU for Instance: 97.2
%DB time waiting for CPU - Resource Mgr: 0.0

Memory Statistics
~~~~~~~~~~~~~~~~~ Begin End
Host Mem (MB): 4,054.0 4,054.0
SGA use (MB): 600.0 600.0
PGA use (MB): 126.6 126.8
% Host Mem used for SGA+PGA: 17.92 17.92

Operating System Statistics - Detail Snaps: 137-138

Snap Time Load %busy %user %sys %idle %iowait
--------------- -------- -------- -------- -------- -------- --------
16-Aug 08:00:35 1.0 N/A N/A N/A N/A N/A
16-Aug 09:00:37 1.2 25.8 14.2 11.6 0.1 74.2
-------------------------------------------------------------

关于TOP SQL部分,主要按以下方面进行排序:
SQL ordered by Elapsed Time
SQL ordered by CPU Time
SQL ordered by Gets
SQL ordered by Reads
SQL ordered by Executions
SQL ordered by Parse Calls
SQL ordered by Sharable Memory
SQL ordered by Version Count

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/16648/viewspace-961263/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/16648/viewspace-961263/