6. 基えは3kで、、、、
１ A★B★C
２ B★C★A
３ C★B★A
Copyright ? 2012 Insight Technology, Inc. All Rights Reserved. 6
7. 基えは3kで、、、、
１ A★B★C
２ B★C★A
３ C★B★A
Copyright ? 2012 Insight Technology, Inc. All Rights Reserved. 7
8. 基えは3kで、、、、
C才┳\喘r
B坤瓮鵐謄淵鵐香
A詐o識鮦
３ C★B★A
Copyright ? 2012 Insight Technology, Inc. All Rights Reserved. 8
9. h廠秤鵤┐燭世掘編^h廠ね
HW CPU : 4core
Mem 8GB
OS RHEL 5 64bit
DB Oracle Database 11.2.0.2
Enterprise Edition
Copyright ? 2012 Insight Technology, Inc. All Rights Reserved. 9
10. 撹
B亊サ`バ WEB?APサ`バ
デ`タベ`スサ`バ
Copyright ? 2012 Insight Technology, Inc. All Rights Reserved. 10
11. OLTPI尖SQL┘リジナル彜B
OLTPI尖SQLのy秤
SQL Statistics
~~~~~~~~~~~~~~
% Snap
Statement Total Per Execute Total
--------------- --------------- ------
Buffer Gets: 1,052,361 116,929.0 13.72
Disk Reads: 0 0.0 .00
Rows processed: 3,600 400.0
CPU Time(s/ms): 5 558.8
Elapsed Time(s/ms): 6 674.6
:
Executions: 9
Copyright ? 2012 Insight Technology, Inc. All Rights Reserved. 11
12. OLTPI尖SQL┘瓮鵐謄淵鵐香瓧
OLTPI尖SQLのy秤
SQL Statistics
~~~~~~~~~~~~~~
% Snap
Statement Total Per Execute Total
--------------- --------------- ------
Buffer Gets: 1,870,864 116,929.0 2.08
Disk Reads: 0 0.0 .00
Rows processed: 6,400 400.0
CPU Time(s/ms): 8 479.2
Elapsed Time(s/ms): 26 1,655.3
:
Executions: 16
Copyright ? 2012 Insight Technology, Inc. All Rights Reserved. 12
13. REPORT C嬾墾k伏念のレポ`ト
Top 5 Timed Events Avg %Total
~~~~~~~~~~~~~~~~~~ wait Call
Event Waits Time (s) (ms) Time
----------------------------------------- ------------ ----------- ------ ------
db file scattered read 1,846,915 735 0 55.9
CPU time 152 11.5
PL/SQL lock timer 1 120 ###### 9.1
db file parallel read 31 73 2358 5.6
db file sequential read 152,969 65 0 5.0
----------------------------------------- ------------ ----------- ------ ------
.。oO(仝db file scatterd read々 がTOPだね)
Copyright ? 2012 Insight Technology, Inc. All Rights Reserved. 13
14. REPORT B嬾墾k伏rのレポ`ト
Top 5 Timed Events Avg %Total
~~~~~~~~~~~~~~~~~~ wait Call
Event Waits Time (s) (ms) Time
----------------------------------------- ------------ ----------- ------ ------
CPU time 311 47.0
latch: cache buffers chains 2,635 207 78 31.2
PL/SQL lock timer 1 120 ###### 18.1
control file parallel write 42 6 152 1.0
db file async I/O submit 69 5 67 .7
----------------------------------------- ------------ ----------- ------ ------
.。oO( I/O狼の棋Cイベントがなくなっている。嬾墾どころか
むしろこちらのほうが措挫では)
Copyright ? 2012 Insight Technology, Inc. All Rights Reserved. 14
15. バッチI尖SQL┘リジナル
バッチI尖SQLのy秤
SQL Statistics
~~~~~~~~~~~~~~
% Snap
Statement Total Per Execute Total
--------------- --------------- ------
Buffer Gets: 7,546,904 104,818.1 98.40
Disk Reads: 6,803,691 94,495.7 114.53
Rows processed: 28,800 400.0
CPU Time(s/ms): 175 2,429.0
Elapsed Time(s/ms): 954 13,252.2
:
Executions: 72
Copyright ? 2012 Insight Technology, Inc. All Rights Reserved. 15
16. バッチI尖SQL┘瓮鵐謄淵鵐香瓧
バッチI尖SQLのy秤
SQL Statistics
~~~~~~~~~~~~~~
% Snap
Statement Total Per Execute Total
--------------- --------------- ------
Buffer Gets: 88,412,056 116,947.2 98.09
Disk Reads: 0 0.0 .00
Rows processed: 302,400 400.0
CPU Time(s/ms): 302 399.0
Elapsed Time(s/ms): 728 962.7
:
Executions: 756
Copyright ? 2012 Insight Technology, Inc. All Rights Reserved. 16
17. REPORT B嬾墾k伏rのレポ`ト犀戮咤
Top 5 Timed Events Avg %Total
~~~~~~~~~~~~~~~~~~ wait Call
Event Waits Time (s) (ms) Time
----------------------------------------- ------------ ----------- ------ ------
CPU time 311 47.0
latch: cache buffers chains 2,635 207 78 31.2
PL/SQL lock timer 1 120 ###### 18.1
control file parallel write 42 6 152 1.0
db file async I/O submit 69 5 67 .7
----------------------------------------- ------------ ----------- ------ ------
.。oO(もしかして、みんな￣CPU聞い￣になってないか)
Copyright ? 2012 Insight Technology, Inc. All Rights Reserved. 17
