单实例,DML的时候耗时慢,附AWR。
公司办公平台,今天在保存数据的时候要等待的时间大概在10秒左右,比较异常,以前都是点完保存在1秒内就保存成功了。检查网络和系统都是正常的,麻烦帮忙分析下,谢谢!该awr报告周期太长,无参考意义
Snap Id Snap Time Sessions Cursors/Session
Begin Snap: 9805 06-11月-14 00:00:43 33 10.4
End Snap: 9844 07-11月-14 15:00:15 36 8.5
Elapsed: 2,339.55 (mins)
DB Time: 111.82 (mins)
本帖最后由 xltxb 于 2014-11-7 22:13 编辑
分时段的附件
DB NameDB IdInstanceInst numReleaseRACHost
ZKBR1353673763zkbr110.2.0.3.0NOWIN-YKALZWHQ3EQ
Snap IdSnap TimeSessionsCursors/Session
Begin Snap:984307-11月-14 14:00:02328.8
End Snap:984407-11月-14 15:00:15368.5
Elapsed: 60.22 (mins)
DB Time: 3.57 (mins)
Report SummaryCache Sizes
BeginEnd
Buffer Cache:280M280MStd Block Size:8K
Shared Pool Size:436M436MLog Buffer:6,928K
Load Profile
Per SecondPer Transaction
Redo size:1,263.025,215.40
Logical reads:1,756.017,251.12
Block changes:7.1029.32
Physical reads:0.220.89
Physical writes:0.672.75
User calls:7.9132.66
Parses:5.6423.30
Hard parses:0.702.88
Sorts:3.7215.35
Logons:0.040.16
Executes:9.4639.08
Transactions:0.24
% Blocks changed per Read:0.40Recursive Call %:83.26
Rollback per transaction %:3.66Rows per Sort:62.73
Instance Efficiency Percentages (Target 100%)
Buffer Nowait %:100.00Redo NoWait %:100.00
Buffer Hit %:99.99In-memory Sort %:100.00
Library Hit %:91.34Soft Parse %:87.62
Execute to Parse %:40.39Latch Hit %:100.00
Parse CPU to Parse Elapsd %:92.28% Non-Parse CPU:89.26
Shared Pool Statistics
BeginEnd
Memory Usage %:74.8469.97
% SQL with executions>1:87.2478.02
% Memory for SQL w/exec>1:87.0073.92
Top 5 Timed Events
EventWaitsTime(s)Avg Wait(ms)% Total Call TimeWait Class
CPU time13361.9
control file sequential read43,7981004.8System I/O
db file sequential read703451.6User I/O
control file parallel write1,23511.6System I/O
db file parallel write1,43300.2System I/O
我看了这几分awr,都是上述类似的情况,数据库负载非常低,从awr中无法看出来系统异常,你尝试收集那故障极端时间内的ash 看看是否有发现
页:
[1]