发个测试库生成的报告供大家参考:
[php]
Server Performance RAC report for Database testDB: Snaps 11937 to 11938
DB Id Inst # Instance Host Startup Begin Snap Time End Snap Time Release Elapsed (min) Up time (hrs)
----------- ------ --------- ---------- --------------- --------------- --------------- --------------- --------------- ---------------
2373100035 1 testdb1 test01 26-Nov-08 09:19 26-Nov-08 15:00 26-Nov-08 16:00 11.1.0.6.0 60.45 6.68
2373100035 2 testdb2 test02 18-Nov-08 13:44 26-Nov-08 15:00 26-Nov-08 16:01 11.1.0.6.0 61.07 194.28
2373100035 3 testdb3 test03 18-Nov-08 14:01 26-Nov-08 15:00 26-Nov-08 16:00 11.1.0.6.0 60.27 193.97
2373100035 4 testdb4 test04 12-Nov-08 11:52 26-Nov-08 15:00 26-Nov-08 16:00 11.1.0.6.0 59.53 340.13
Inst # SGA Target DB Cache size Shared Pool Log Buffer PGA Target
------ --------------- --------------- --------------- --------------- ---------------
1 10240M 3904M 2048M 16015K 20480M
2 10240M 3904M 2048M 16015K 20480M
3 10240M 3904M 2048M 16015K 20480M
4 10240M 4416M 2048M 16015K 20480M
OS Stat
~~~~~~~
Num Load Load
Inst # CPUs Begin End % Busy % Usr % Sys % WIO % Idl Busy Time (s) Idle Time (s) Total time (s)
------ ---- ------ ------ ------ ------ ------ ------ ------ --------------- --------------- ---------------
1 8 2.4 1.5 12.0 11.6 .3 .6 88.0 3,477.98 25,545.03 29,023.01
2 8 .2 1.6 11.4 10.9 .4 .2 88.6 3,325.14 25,925.62 29,250.76
3 8 1.3 .5 9.0 8.5 .5 .2 91.0 2,587.27 26,236.51 28,823.78
4 8 2.1 1.2 5.8 5.3 .4 .2 94.2 1,663.23 26,966.30 28,629.53
--------------- --------------- ---------------
sum 11,053.62 104,673.46 115,727.08
Time Model
~~~~~~~~~~
SQL Exec Hard Parse
Inst # DB time (s) DB CPU (s) Ela (s) Parse Ela (s) Ela (s) PL/SQL Ela (s) Java Ela (s) bg time (s) bg CPU (s)
------ --------------- --------------- --------------- --------------- --------------- --------------- --------------- --------------- ---------------
1 6,024.66 2,825.02 3,001.71 8.61 .24 .69 .00 2,514.42 544.94
2 3,728.05 2,611.58 2,627.59 .13 .00 .54 .00 1,787.98 456.29
3 1,895.24 1,628.93 1,643.08 .15 .00 .35 .00 1,206.39 666.39
4 718.82 712.05 717.65 .09 .00 .07 .00 847.11 546.92
--------------- --------------- --------------- --------------- --------------- --------------- --------------- --------------- ---------------
sum 12,366.78 7,777.58 7,990.03 8.98 .24 1.65 .00 6,355.90 2,214.54
Time Model - % of DB time
~~~~~~~~~~~~~~~~~~~~~~~~~
% Total DB CPU SQL Exec Ela Parse Ela Hard Parse PL/SQL Ela Java Ela % Total bg CPU
Inst # DB time %DB time %DB time %DB time %DB time %DB time %DB time bg time %bg time
------ --------------- --------------- --------------- --------------- --------------- --------------- --------------- --------------- ---------------
1 48.72 46.89 49.82 .14 .00 .00 .00 39.56 21.67
2 30.15 70.05 70.48 .00 .00 .00 .00 28.13 25.52
3 15.32 85.95 86.70 .01 .00 .00 .00 18.98 55.24
4 5.81 99.06 99.84 .01 .00 .00 .00 13.33 64.56
SysStat
~~~~~~~
Logical Physical Physical Redo Block User
I# Reads Reads Writes Size (k) Changes Calls Execs Parses Logons Txns
---- --------------- ------------ ------------ ------------ ------------ ------------ ------------ ------------ ---------- ------------
1 3,021,361 44,113 53,650 91,472 195,945 4,431 9,270 6,324 333 973
2 120,326 4,498 2,462 3,170 8,608 1,552 6,246 3,754 282 323
3 97,798 135 879 2,414 4,785 1,970 4,873 3,017 293 192
4 23,706 1,761 1,088 1,985 3,587 1,450 3,031 1,741 263 139
--------------- ------------ ------------ ------------ ------------ ------------ ------------ ------------ ---------- ------------
sum 3,263,191 50,507 58,079 99,042 212,925 9,403 23,420 14,836 1,171 1,627
SysStat per Sec
~~~~~~~~~~~~~~~
Logical Physical Physical Redo Block User
I# Reads/s Reads/s Writes/s Size (k)/s Changes/s Calls/s Execs/s Parses/s Logons/s Txns/s
---- --------------- ------------ ------------ ------------ ------------ ------------ ------------ ------------ ---------- ------------
1 833.15 12.2 14.8 25.2 54.0 1.2 2.6 1.7 .09 .3
2 32.84 1.2 .7 .9 2.3 .4 1.7 1.0 .08 .1
3 27.05 .0 .2 .7 1.3 .5 1.3 .8 .08 .1
4 6.64 .5 .3 .6 1.0 .4 .8 .5 .07 .0
--------------- ------------ ------------ ------------ ------------ ------------ ------------ ------------ ---------- ------------
sum 899.68 13.9 16.0 27.3 58.7 2.6 6.5 4.1 .32 .4
SysStat per Tx
~~~~~~~~~~~~~~
Logical Physical Physical Redo Block User
I# Reads/tx Reads/tx Writes/tx Size (k)/tx Changes/tx Calls/tx Execs/tx Parses/tx Logons/tx
---- --------------- ------------ ------------ ------------ ------------ ------------ ------------ ------------ ----------
1 3,105.20 45.3 55.1 94.0 201.4 4.6 9.5 6.5 .34
2 372.53 13.9 7.6 9.8 26.7 4.8 19.3 11.6 .87
3 509.36 .7 4.6 12.6 24.9 10.3 25.4 15.7 1.53
4 170.55 12.7 7.8 14.3 25.8 10.4 21.8 12.5 1.89
--------------- ------------ ------------ ------------ ------------ ------------ ------------ ------------ ----------
avg 1,039.41 18.2 18.8 32.7 69.7 7.5 19.0 11.6 1.16
SysStat and GE Misc - RAC
~~~~~~~~~~~~~~~~~~~~~~~~~
GC Current GC CR GC Current GC CR
Blocks Blocks Blocks Blocks IPC GC Messages GE Messages Msgs Rcvd Msgs Sent Msgs Sent GC Blks GC CR
I# Received Received Served Served GC CPU (s) CPU (s) Sent Sent Actual Direct Indirect Lost Failure
---- ----------- ----------- ----------- ----------- ---------- ---------- -------------- ----------- ----------- ----------- ----------- ------- --------
2 579 393 12,759 537 7 0 14,525 13,801 60,672 7,443 4,173 0 0
3 532 343 10,619 352 4 0 10,755 16,905 38,142 5,002 2,280 0 0
4 487 325 466 305 3 0 11,762 13,873 25,115 7,782 2,569 0 0
----------- ----------- ----------- ----------- ---------- ---------- -------------- ----------- ----------- ----------- ----------- ------- --------
sum 1,598 1,061 23,844 1,194 14 0 37,042 44,579 123,929 20,227 9,022 0 0
SysStat and GE Misc (per Sec) - RAC
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
GC Current GC CR GC Current GC CR
Blocks Blocks Blocks Blocks GC IPC GC Messages GE Messages Msgs Rcvd Msgs Sent Msgs Sent GC Blks GC CR
I# Received/s Received/s Served/s Served/s CPU(s) /s CPU (s)/s Sent/s Sent/s Actual/s Direct/s Indirect/s Lost/s Fail/s
---- ----------- ----------- ----------- ----------- ---------- ---------- -------------- ----------- ----------- ----------- ----------- ------- --------
2 .16 .11 3.48 .15 .00 .00 3.96 3.77 16.56 2.03 1.14 .0 .0
3 .15 .09 2.94 .10 .00 .00 2.97 4.68 10.55 1.38 .63 .0 .0
4 .14 .09 .13 .09 .00 .00 3.29 3.88 7.03 2.18 .72 .0 .0
----------- ----------- ----------- ----------- ---------- ---------- -------------- ----------- ----------- ----------- ----------- ------- --------
sum .44 .29 6.55 .33 .00 .00 10.23 12.33 34.14 5.59 2.49 .0 .0
SysStat and GE Misc (per Tx) - RAC
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
GC Current GC CR GC Current GC CR GC CR
Blocks Blocks Blocks Blocks GC IPC GC Messages GE Messages Msgs Rcvd Msgs Sent Msgs Sent GC Blks Fail
I# Received/tx Received/tx Served/tx Served/tx CPU (s)/tx CPU (s)/tx Sent/tx Sent/tx Actual/tx Direct/tx Indirect/tx Lost/tx /tx
---- ----------- ----------- ----------- ----------- ---------- ---------- -------------- ----------- ----------- ----------- ----------- ------- --------
2 1.79 1.22 39.50 1.66 .02 .00 44.97 42.73 187.84 23.04 12.92 .0 .0
3 2.77 1.79 55.31 1.83 .02 .00 56.02 88.05 198.66 26.05 11.88 .0 .0
4 3.50 2.34 3.35 2.19 .02 .00 84.62 99.81 180.68 55.99 18.48 .0 .0
----------- ----------- ----------- ----------- ---------- ---------- -------------- ----------- ----------- ----------- ----------- ------- --------
avg 2.69 1.78 32.72 1.90 .02 .00 61.87 76.86 189.06 35.03 14.43 .0 .0
..
[/php]