statspack报告
上一篇 /
下一篇 2008-10-15 20:09:39
/ 个人分类:Oracle
今天成功地在公司装完statspack,没有任何错误,不像在宿舍会遇到前面说的问题,接下来开始研究报告所体现的意义。我测试了一下,生成了一个报告,我把报告贴上来,之后若有研究出东西再上来更新。
STATSPACK report for
Load Profile ~~~~~~~~~~~~ Per Second Per Transaction --------------- ---------------
Redo size: 1,511.85 32,371.29
Logical reads: 13.69 293.06
Block changes: 3.87 82.94
Physical reads: 2.67 57.12
Physical writes: 2.67 57.12
User calls: 1.98 42.35
Parses: 0.69 14.76
Hard parses: 0.05 1.06
Sorts: 0.43 9.29
Logons: 0.00 0.00
Executes: 1.29 27.71
Transactions: 0.05
% Blocks changed per Read: 28.30 Recursive Call %: 60.59
Rollback per transaction %: 0.00 Rows per Sort: 164.76
Instance Efficiency Percentages (Target 100%) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Buffer Nowait %: 100.00 Redo NoWait %: 100.00
Buffer Hit %: 99.90 In-memory Sort %: 98.73
Library Hit %: 93.72 Soft Parse %: 92.83
Execute to Parse %: 46.71 Latch Hit %: 99.99
Parse CPU to Parse Elapsd %: 87.50 % Non-Parse CPU: 88.89
Shared Pool Statistics Begin End ------ ------
Memory Usage %: 71.80 72.75
% SQL with executions>1: 96.18 96.63
% Memory for SQL w/exec>1: 84.77 88.58
Top 5 Timed Events
~~~~~~~~~~~~~~~~~~ % Total
Event Waits Time (s) Ela Time
-------------------------------------------- ------------ ----------- --------
CPU time 1 61.83
control file parallel write 118 0 13.03
direct path read 68 0 11.12
db file sequential read 5 0 3.68
log file parallel write 115 0 2.91
-------------------------------------------------------------
Wait Events for DB: AAAAA Instance: AAAAA Snaps: 1 -2
-> s - second
-> cs - centisecond - 100th of a second
-> ms - millisecond - 1000th of a second
-> us - microsecond - 1000000th of a second
-> ordered by wait time desc, waits desc (idle events last)
还是贴比较重点的部分出来~~~
收藏
举报
TAG:
Oracle