How to begin about tackle I/O problem?
AWR is taken at peak time the db time is twice as much as elapsed time.
Snap Id Snap Time Sessions Curs/Sess
--------- ------------------- -------- ---------
Begin Snap: 29877 12-Jun-12 09:00:20 1,538 23.0
End Snap: 29878 12-Jun-12 10:00:38 1,762 24.6
Elapsed: 60.31 (mins)
DB Time: 102.94 (mins)
Cache Sizes
~~~~~~~~~~~ Begin End
---------- ----------
Buffer Cache: 64M 64M Std Block Size: 8K
Shared Pool Size: 832M 832M Log Buffer: 14,400K
Load Profile
~~~~~~~~~~~~ Per Second Per Transaction
--------------- ---------------
Redo size: 109,588.14 21,661.27
Logical reads: 39,478.24 7,803.30
Block changes: 736.77 145.63
Physical reads: 4,841.26 956.93
Physical writes: 64.09 12.67
User calls: 1,285.85 254.16
Parses: 59.40 11.74
Hard parses: 1.10 0.22
Sorts: 5.83 1.15
Logons: 0.50 0.10
Executes: 630.45 124.62
Transactions: 5.06
% Blocks changed per Read: 1.87 Recursive Call %: 9.74