Optimize Distributed Workload - Expert Oracle RAC Performance Diagnostics and Tuning - page 524

1 TICKS CRE_BULK_DATA_LOADER DB CPU 3040543
1 TICKS CRE_BULK_DATA_LOADER DB time 153181110
1 TICKS CRE_BULK_DATA_LOADER cluster wait time 123924946
1 TICKS CRE_BULK_DATA_LOADER concurrency wait time 5333193
1 TICKS CRE_BULK_DATA_LOADER db block changes 4911
1 TICKS CRE_BULK_DATA_LOADER execute count 13035
1 TICKS CRE_BULK_DATA_LOADER gc cr block receive time 858
1 TICKS CRE_BULK_DATA_LOADER gc current block receive time 5605
1 TICKS CRE_BULK_DATA_LOADER gc current blocks received 647
1 TICKS CRE_BULK_DATA_LOADER opened cursors cumulative 9123
1 TICKS CRE_BULK_DATA_LOADER parse count (total) 1289
1 TICKS CRE_BULK_DATA_LOADER parse time elapsed 271372
1 TICKS CRE_BULK_DATA_LOADER redo size 901224
1 TICKS CRE_BULK_DATA_LOADER session cursor cache hits 4294909653
1 TICKS CRE_BULK_DATA_LOADER session logical reads 32741
1 TICKS CRE_BULK_DATA_LOADER sql execute elapsed time 152791384
1 TICKS CRE_BULK_DATA_LOADER user I/O wait time 20580395
1 TICKS CRE_BULK_DATA_LOADER user calls 3163
2 TAPS TAP_BULK_DATA_LOADER DB CPU 20996
2 TAPS TAP_BULK_DATA_LOADER DB time 23571
2 TAPS TAP_BULK_DATA_LOADER concurrency wait time 1853
2 TAPS TAP_BULK_DATA_LOADER sql execute elapsed time 1561
2 TAPS TAP_BULK_DATA_LOADER DB CPU 3409137796
2 TAPS TAP_BULK_DATA_LOADER DB time 2.4099E+11
2 TAPS TAP_BULK_DATA_LOADER application wait time 2184882
2 TAPS TAP_BULK_DATA_LOADER cluster wait time 1.2299E+11
2 TAPS TAP_BULK_DATA_LOADER concurrency wait time 2.4219E+10
2 TAPS TAP_BULK_DATA_LOADER db block changes 10156572
2 TAPS TAP_BULK_DATA_LOADER execute count 4131093
2 TAPS TAP_BULK_DATA_LOADER gc cr block receive time 232311
2 TAPS TAP_BULK_DATA_LOADER gc cr blocks received 746592
2 TAPS TAP_BULK_DATA_LOADER gc current block receive time 858191
2 TAPS TAP_BULK_DATA_LOADER gc current blocks received 1209331
2 TAPS TAP_BULK_DATA_LOADER opened cursors cumulative 2825101
2 TAPS TAP_BULK_DATA_LOADER parse count (total) 882390
2 TAPS TAP_BULK_DATA_LOADER parse time elapsed 40182318
2 TAPS TAP_BULK_DATA_LOADER physical reads 45364
2 TAPS TAP_BULK_DATA_LOADER redo size 1807920872
2 TAPS TAP_BULK_DATA_LOADER session cursor cache hits 1.2455E+11
2 TAPS TAP_BULK_DATA_LOADER session logical reads 132062344
2 TAPS TAP_BULK_DATA_LOADER sql execute elapsed time 1.5694E+11
2 TAPS TAP_BULK_DATA_LOADER user I/O wait time 2934858941
2 TAPS TAP_BULK_DATA_LOADER user calls 1301025
3 RACGRUD Toad.exe DB time 916476497
3 RACGRUD Toad.exe application wait time 20135
3 RACGRUD Toad.exe cluster wait time 22852151
3 RACGRUD Toad.exe concurrency wait time 14291
3 RACGRUD Toad.exe gc cr block receive time 971
3 RACGRUD Toad.exe gc cr blocks received 60114
3 RACGRUD Toad.exe parse time elapsed 1250097
3 RACGRUD Toad.exe physical reads 14203147