select event, total_waits, time_waited, average_wait from sys.v_$session_event where sid = <session_id>


________________________________

From: AlanV [mailto:[Email address protected]
Sent: Tue 31/01/2006 17:26
To: Sreedhar_Bhaskararaju
Subject: RE: Query Waiting Time



**A LazyDBA.com subscriber has responded to your lazydba.com post**
**LazyDBA.com mail shield has forwarded you this email,
**and removed any attachments, and kept your email address secret
**from this person, and any viruses/trojans.
**If you reply to this email, the person will see your email address as normal
**Anything below this line is the original email text


How did you generate the statistics below?

-----Original Message-----
From: Sreedhar_Bhaskararaju
[Email address protected]
Sent: Monday, January 30, 2006 5:32 AM
To: LazyDBA Discussion
Subject: Query Waiting Time


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.


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html









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