SQL> @response_time_breakdown MAJOR MINOR WAIT_EVENT SECONDS PCT -------- ------------- ---------------------------------------- -------- ------ CPU time parsing n/a 497 .57% reloads n/a 13 .01% execution n/a 52618 59.99% disk I/O normal I/O db file sequential read 21980 25.06% full scans db file scattered read 9192 10.48% direct I/O direct path read 1484 1.69% direct path write 354 .40% other I/O log file sequential read 9 .01% db file parallel read 0 .00% control file sequential read 0 .00% control file parallel write 0 .00% waits DBWn writes rdbms ipc reply 143 .16% free buffer waits 36 .04% checkpoint completed 31 .04% LGWR writes log file switch completion 698 .80% other locks latch free 496 .57% sort segment request 108 .12% latency commits log file sync 6 .01% network SQL*Net break/reset to client 18 .02% SQL*Net more data to client 8 .01% SQL*Net message to client 7 .01% SQL*Net more data from client 3 .00% file ops file open 4 .01% file identify 1 .00% misc instance state change 0 .00%