Excesso de Leituras Físicas

[mpvargasParticipante]

ADDM
Horário de Captura do Snapshot Final 05/02/2009 16:03:20

Report Summary
Cache Sizes
Begin End
Buffer Cache: 5,936M 5,920M Std Block Size: 8K
Shared Pool Size: 288M 304M Log Buffer: 14,396K

Load Profile
Per Second Per Transaction
Redo size: 122,126.20 12,519.01
Logical reads: 109,112.55 11,185.00
Block changes: 709.93 72.77
Physical reads: 101,840.32 10,439.53
Physical writes: 9.28 0.95
User calls: 6,528.28 669.21
Parses: 767.82 78.71
Hard parses: 117.33 12.03
Sorts: 219.96 22.55
Logons: 10.90 1.12
Executes: 1,074.21 110.12
Transactions: 9.76

% Blocks changed per Read: 0.65 Recursive Call %: 27.94
Rollback per transaction %: 0.21 Rows per Sort: 3.90

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00 Redo NoWait %: 100.00
Buffer Hit %: 98.76 In-memory Sort %: 100.00
Library Hit %: 89.96 Soft Parse %: 84.72
Execute to Parse %: 28.52 Latch Hit %: 99.55
Parse CPU to Parse Elapsd %: 77.87 % Non-Parse CPU: 76.40

Shared Pool Statistics
Begin End
Memory Usage %: 91.91 91.39
% SQL with executions>1: 58.51 50.25
% Memory for SQL w/exec>1: 74.64 52.85

Top 5 Timed Events

Event Waits Time(s) Avg Wait(ms) % Total Call Time Wait Class
db file sequential read 86,225 426 5 31.5 User I/O
CPU time 339 25.1
log file sync 1,792 93 52 6.9 Commit
db file scattered read 11,341 88 8 6.5 User I/O
log file parallel write 1,931 75 39 5.5 System I/O