Database Time Spent Waiting (%): Wait Class Other

[muzammil.dba]

AWR Report:

DB cpu (seconds) 0.00 0.00 0.00
DB time (seconds) 10793.85 2.99 0.63
db block changes 306559.00 84.87 17.94
execute count 99084.00 27.43 5.80
global cache cr block receive time (seconds) 0.00 0.00 0.00
global cache cr blocks received 0.00 0.00 0.00
global cache current block receive time (seconds) 0.00 0.00 0.00
global cache current blocks received 0.00 0.00 0.00
global cache get time (seconds) 0.00 0.00 0.00
global cache gets 0.00 0.00 0.00
opened cursors cumulative 15820.00 4.38 0.93
parse count (total) 16720.00 4.63 0.98
parse time cpu (seconds) 0.09 0.00 0.00
parse time elapsed (seconds) 0.26 0.00 0.00
physical reads 14.00 0.00 0.00
physical writes 6446.00 1.78 0.38
redo size (KB) 50233.90 13.91 2.94
session cursor cache hits 8794.00 2.43 0.51
session logical reads 1077166.00 298.22 63.03
sql execute cpu time (seconds) 0.00 0.00 0.00
sql execute elapsed time (seconds) 0.00 0.00 0.00
user calls 20412.00 5.65 1.19
user commits 13039.00 3.61 0.76
user rollbacks 4051.00 1.12 0.24
workarea executions - multipass 0.00 0.00 0.00
workarea executions - onepass 0.00 0.00 0.00
workarea executions - optimal 2697.00 0.75 0.16