分析一数据库7月份与3月份的Load Profile 对比:
Snap Id Snap TimeSessions Curs/Sess Comment
------- ------------------ -------- --------- -------------------
Begin Snap: 1 08-7月 -04 15:00:0656 2.8
End Snap: 3 08-7月 -04 15:32:3857 2.8
Elapsed:
32.53 (mins)
Cache Sizes (end)
~~~~~~~~~~~~~~~~~
Buffer Cache: 480MStd Block Size: 8K
Shared Pool Size: 360M
Log Buffer: 512K
Load Profile
~~~~~~~~~~~~
Per Second Per Transaction
--------------- ---------------
Redo size:
11,320.33
21,813.71
Logical reads:
7,378.35
14,217.71
Block changes:
20.51
39.51
Physical reads:
2,648.09
5,102.74
Physical writes:
5.56
10.72
User calls:
91.10
175.55
Parses:
18.88
36.37
Hard parses:
0.70
1.34
Sorts:
3.68
7.10
Logons:
0.03
0.05
Executes:
19.64
37.85
Transactions:
0.52red[/COLOR]
Snap Id Snap TimeSessions Curs/Sess Comment
------- ------------------ -------- --------- -------------------
Begin Snap: 861 24-3ÔÂ -04 15:00:0674 1.6
End Snap: 862 24-3ÔÂ -04 16:00:0575 2.2
Elapsed:
59.98 (mins)
Cache Sizes (end)
~~~~~~~~~~~~~~~~~
Buffer Cache: 304MStd Block Size: 8K
Shared Pool Size: 360M
Log Buffer: 512K
Load Profile
~~~~~~~~~~~~
Per Second Per Transaction
--------------- ---------------
Redo size:
4,802.76
11,585.20
Logical reads:
21,635.38
52,188.82
Block changes:
11.12
26.82
Physical reads:
1,952.23
4,709.16
Physical writes:
26.15
63.08
User calls:
91.57
220.89
Parses:
16.89
40.73
Hard parses:
0.66
1.60
Sorts:
2.72
6.56
Logons:
0.04
0.08
Executes:
17.22
41.55
Transactions:
0.41
red[/COLOR] red[/COLOR] red[/COLOR]
这是不是表明数据文件中存在较多碎片,导致一次写 写入到了多个不同的数据块?
如果是这样,还有没有其它的数据来表明数据文件中碎片过多?
|