Skip to Main Content

In my AWR report in which section i have to work on performance

AryacoolJun 19 2014 — edited Aug 22 2014

Hi My AWR report please tell me which are my problematic are ,

DB NameDB IdInstanceInst numStartup TimeReleaseRAC
xxxxxxxx2155480196xxxxxxxxx106-Jun-14 19:0611.2.0.2.0NO

Host NamePlatformCPUsCoresSocketsMemory (GB)
xxxxxxxxxxxxxxxxxxxxxxxxxLinux x86 64-bit168294.39

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:2493919-Jun-14 05:00:43775.6
End Snap:2494119-Jun-14 07:00:52726.2
Elapsed: 120.15 (mins)
DB Time: 392.37 (mins)

Report Summary

Cache Sizes

BeginEnd
Buffer Cache:5,184M5,184MStd Block Size:8K
Shared Pool Size:736M736MLog Buffer:16,532K

Load Profile

Per SecondPer TransactionPer ExecPer Call
DB Time(s):3.31.50.023.77
DB CPU(s):0.40.20.000.47
Redo size:48,546.922,158.1
Logical reads:39,852.618,189.8
Block changes:322.0147.0
Physical reads:4,248.21,939.0
Physical writes:1,177.3537.4
User calls:0.90.4
Parses:1.50.7
Hard parses:0.10.0
W/A MB processed:0.20.1
Logons:0.00.0
Executes:153.970.3
Rollbacks:0.00.0
Transactions:2.2

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %:99.85Redo NoWait %:100.00
Buffer Hit %:96.08In-memory Sort %:99.94
Library Hit %:99.76Soft Parse %:93.98
Execute to Parse %:99.04Latch Hit %:99.89
Parse CPU to Parse Elapsd %:46.21% Non-Parse CPU:99.57

Shared Pool Statistics

BeginEnd
Memory Usage %:66.4968.07
% SQL with executions>1:89.3291.02
% Memory for SQL w/exec>1:79.9277.05

Top 5 Timed Foreground Events

EventWaitsTime(s)Avg wait (ms)% DB timeWait Class
db file sequential read2,705,56612,994555.20User I/O
DB CPU2,95712.56
direct path read temp724,8972,382310.12User I/O
read by other session371,7391,62346.89User I/O
direct path write temp116,2401,445126.14User I/O

Host CPU (CPUs: 16 Cores: 8 Sockets: 2)

Load Average BeginLoad Average End%User%System%WIO%Idle
1.622.922.50.210.597.2

Instance CPU

%Total CPU%Busy CPU%DB time waiting for CPU (Resource Manager)
2.692.30.0

Memory Statistics

BeginEnd
Host Mem (MB):96,657.296,657.2
SGA use (MB):6,656.06,656.0
PGA use (MB):1,365.51,872.2
% Host Mem used for SGA+PGA:8.308.82

If anything more required tell please suggest me what should be my approach to performance tuning .

Regards,

Comments
Post Details
Added on Jun 19 2014
29 comments
29,249 views