Đang chuẩn bị nút TẢI XUỐNG, xin hãy chờ
Tải xuống
Example of Statspack Report | Example of Statspack Report STATSPACK report for DB Name DB Id Instance Inst Num Release Cluster Host ------------ ----------- ------------ -------- ----------- ------- ------------ ORCL 995156390 orcl 1 9.2.0.1.0 NO EDT3R4P1 Snap Id Snap Time Sessions Curs/Sess Comment ------- ------------------ -------- --------- ------------------- Begin Snap: 1 30-Jul-02 15:14:22 7 5.0 End Snap: 2 30-Jul-02 16:01:23 7 5.9 Elapsed: 47.02 (mins) Cache Sizes (end) ~~~~~~~~~~~~~~~~~ Buffer Cache: 4M Std Block Size: 4K Shared Pool Size: 8M Log Buffer: 63K Load Profile ~~~~~~~~~~~~ Per Second Per Transaction --------------- --------------- Redo size: 897.28 2,981.43 Logical reads: 775.82 2,577.84 Block changes: 6.52 21.65 Physical reads: 718.92 2,388.78 Physical writes: 5.58 18.55 User calls: 0.21 0.71 Parses: 1.05 3.47 Hard parses: 0.03 0.11 Sorts: 0.19 0.65 Logons: 0.01 0.02 Executes: 2.98 9.89 Transactions: 0.30 % Blocks changed per Read: 0.84 Recursive Call %: 98.36 Rollback per transaction %: 0.00 | Example of Statspack Report STATSPACK report for DB Name DB Id Instance Inst Num Release Cluster Host ------------ ----------- ------------ -------- ----------- ------- ------------ ORCL 995156390 orcl 1 9.2.0.1.0 NO EDT3R4P1 Snap Id Snap Time Sessions Curs/Sess Comment ------- ------------------ -------- --------- ------------------- Begin Snap: 1 30-Jul-02 15:14:22 7 5.0 End Snap: 2 30-Jul-02 16:01:23 7 5.9 Elapsed: 47.02 (mins) Cache Sizes (end) ~~~~~~~~~~~~~~~~~ Buffer Cache: 4M Std Block Size: 4K Shared Pool Size: 8M Log Buffer: 63K Load Profile ~~~~~~~~~~~~ Per Second Per Transaction --------------- --------------- Redo size: 897.28 2,981.43 Logical reads: 775.82 2,577.84 Block changes: 6.52 21.65 Physical reads: 718.92 2,388.78 Physical writes: 5.58 18.55 User calls: 0.21 0.71 Parses: 1.05 3.47 Hard parses: 0.03 0.11 Sorts: 0.19 0.65 Logons: 0.01 0.02 Executes: 2.98 9.89 Transactions: 0.30 % Blocks changed per Read: 0.84 Recursive Call %: 98.36 Rollback per transaction %: 0.00 Rows per Sort: 3677.05 Instance Efficiency Percentages (Target 100%) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Buffer Nowait %: 98.34 Redo NoWait %: 100.00 Buffer Hit %: 7.59 In-memory Sort %: 74.50 Library Hit %: 97.33 Soft Parse %: 96.95 Execute to Parse %: 64.88 Latch Hit %: 100.00 Parse CPU to Parse Elapsd %: 2.11 % Non-Parse CPU: 99.66 Shared Pool Statistics Begin End ------ ------ Memory Usage %: 94.93 95.69 % SQL with executions>1: 71.80 87.21 % Memory for SQL w/exec>1: 48.25 84.48 Top 5 Timed Events ~~~~~~~~~~~~~~~~~~ % Total Event Waits Time (s) Ela Time -------------------------------------------- ------------ ----------- -------- db file sequential read 189,111 29,773 50.93 db file scattered read 130,326 25,114 42.96 buffer busy waits 36,307 2,031 3.47 enqueue 724 535 .91 direct path read 3,085 325 .56 ------------------------------------------------------------- Wait Events for DB: ORCL Instance: orcl Snaps: 1 -2 -> s - second -> cs - centisecond - 100th of a second ->
