Hi All,

One of my query is taking 1.10 minutes to execute. If I check waiting times I got the following wait times. How do I get break up for 1.10 Min, where do I see for that information?

EVENT, TOTAL_WAITS, TIME_WAITED
buffer busy waits, 2.00, 0.00
log buffer space, 59.00 , 424.00
log file switch completion, 2.00, 38.00
log file sync , 1.00 , 1.00
db file sequential read, 1,271.00, 574.00
direct path read, 12.00, 0.00
direct path write, 2.00, 0.00
undo segment extension, 11.00, 0.00
SQL*Net message to client, 24.00, 0.00
SQL*Net message from client, 23.00, 26,036.00

Thanks in advance for your kind help.

Regs,
Sree


DISCLAIMER:
This email (including any attachments) is intended for the sole use of the intended recipient/s and may contain material that is CONFIDENTIAL AND PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or distribution or forwarding of any or all of the contents in this message is STRICTLY PROHIBITED. If you are not the intended recipient, please contact the sender by email and delete all copies; your cooperation in this regard is appreciated.

Oracle LazyDBA home page