| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Tkprof ouput -- Query on times waited/max waited/total waited
Hi Cary,
Very Glad to see your reply. Thank you so much for enlightening us.
Best Regards
Sriram Kumar
=20
-----Original Message-----
From: Cary Millsap [mailto:cary.millsap_at_hotsos.com]=20
Sent: Thursday, February 05, 2004 7:57 PM
To: oracle-l_at_freelists.org
Subject: RE: Tkprof ouput -- Query on times waited/max waited/total =
waited
Responses in-line.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
* Nullius in verba *
Upcoming events:
- Performance Diagnosis 101: 2/24 San Diego, 3/23 Park City, 4/6 Seattle - SQL Optimization 101: 2/16 Dallas - Hotsos Symposium 2004: March 7-10 Dallas - Visit www.hotsos.com for schedule details...
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of =
k.sriramkumar_at_iflexsolutions.com
Sent: Thursday, February 05, 2004 4:39 AM
To: oracle-l_at_freelists.org
Subject: Tkprof ouput -- Query on times waited/max waited/total waited
Importance: High
Hi Gurus,
I was analyzing the output of 10046 event of a single session. Myself and my fellow coleage differ in the interpretation of the output = statistics.
Question 1
=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D
The output Reads
Elapsed times include waiting on following events:
Event waited on Times Max. Wait TotalWaited
My Understanding of this output is=3D20
Times waited -- Number of times this event has waited. Here the user = might have entered 7 statements hence it says number of times waited as = 6
[Cary Millsap] Close. It means that there were six occasions when the db = server was awaiting input from the client. It probably means that there = were about six dbcalls, but even this can vary because of call bundling, = pre-fetching, and so on.
Max Waited -- Maximum duration of wait (Out of the 6 times it has = waited)
[Cary Millsap] Yes. You can confirm this by checking the raw trace data.
Total Waited -- Total Waiting time ( sigma of 6 wait times )
[Cary Millsap] Yes. Again, this is easy to confirm by examining the = input data to tkprof.
Pls confirm whether my understanding is correct.
Question 2
=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D
Say I turn on the SQL tracing at 12.00 and the session is idle till 1.00 = and a single SQL statement is executed at 1.00.
Now if I analyze the ouput.
My undestanding is that, this 1 hour would be accounted in the "SQL*Net = message from client" . Is my understanding correct??
[Cary Millsap] Yes. This is what I call in Jeff's and my book = "collection error." You probably don't need to optimize that hour, so = you shouldn't collect timing data for that hour.
Best Regards
Sriram Kumar
DISCLAIMER:
This message contains privileged and confidential information and is =3D =
intended only for the individual named.If you are not the intended =3D =
recipient you should not disseminate,distribute,store,print, copy or =3D =
deliver this message.Please notify the sender immediately by e-mail if =
=3D you have received this e-mail by mistake and delete this e-mail from =
=3D your system.E-mail transmission cannot be guaranteed to be secure or =
=3D error-free as information could be =3D =
intercepted,corrupted,lost,destroyed,arrive late or incomplete or =3D =
contain viruses.The sender therefore does not accept liability for any =
=3D errors or omissions in the contents of this message which arise as a =
=3D result of e-mail transmission. If verification is required please =
=3D request a hard-copy version.
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request_at_freelists.org put = 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- DISCLAIMER: This message contains privileged and confidential information and is = intended only for the individual named.If you are not the intended = recipient you should not disseminate,distribute,store,print, copy or = deliver this message.Please notify the sender immediately by e-mail if = you have received this e-mail by mistake and delete this e-mail from = your system.E-mail transmission cannot be guaranteed to be secure or = error-free as information could be = intercepted,corrupted,lost,destroyed,arrive late or incomplete or = contain viruses.The sender therefore does not accept liability for any = errors or omissions in the contents of this message which arise as a = result of e-mail transmission. If verification is required please = request a hard-copy version. ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Thu Feb 05 2004 - 22:45:22 CST
 |
 |