Листинг 1. Первая страница обычного отчета Statspack
Первая страница обычного отчета Statspack включает наиболее важные системные данные
STATSPACK report for
DB Name DB Id Instance Inst Num Release OPS Host
------- ---------- -------- ----------- --------- --- --------
MAIL 4221457278 MAIL 1 8.1.6.0.0 YES mailhost
Snap Length
Start Id End Id Start Time End Time (Minutes)
------- ------- ------------------- ------------------ --------
2327 2329 24-Nov-99 11:00:26 24-Nov-99 13:00:37 120.18
Cache Sizes
db_block_buffers: 38000
db_block_size: 8192
log_buffer: 1048576
shared_pool_size: 150M
Load Profile
Per Second Per Transaction
------------ ----------------
Redo size: 15,689.18 3,922.02
Logical reads: 21,549.53 5,387.01
Block changes: 76.07 19.02
Physical reads: 12.53 3.13
Physical writes: 3.64 0.91
User calls: 210.33 52.58
Parses: 8.13 2.03
Hard parses: 0.00 0.00
Sorts: 6.18 1.54
Transactions: 4.00
Rows per Sort: 11.53
Pct Blocks changed / Read: 0.35
Recursive Call Pct: 14.94
Rollback / transaction Pct: 2.52
Instance Efficiency Percentages (Target 100%)
Buffer Nowait Ratio: 100.00
Buffer Hit Ratio: 99.94
Library Hit Ratio: 100.00
Redo NoWait Ratio: 100.00
In-memory Sort Ratio: 99.95
Soft Parse Ratio: 99.94
Latch Hit Ratio: 97.86
Top 5 Wait Events
Wait % Total
Event Waits Time (cs) Wt Time
-------------------------- ------ --------- -------
db file sequential read 67,254 73,087 44.77
log file sync 28,252 30,550 18.71
log file parallel write 28,310 26,304 16.11
db file parallel write 2,681 9,430 5.78
global cache cr request 32,825 5,586 3.42