RE: Tkprof ouput -- Query on times waited/max waited/total waited

  • From: <k.sriramkumar@xxxxxxxxxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 6 Feb 2004 10:15:22 +0530

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@xxxxxxxxxx]=20
Sent: Thursday, February 05, 2004 7:57 PM
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of =
k.sriramkumar@xxxxxxxxxxxxxxxxxx
Sent: Thursday, February 05, 2004 4:39 AM
To: oracle-l@xxxxxxxxxxxxx
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  Total
Waited
  ----------------------------------------   Waited  ----------
------------
  SQL*Net message to client                       6        0.00
0.00
  SQL*Net message from client                     5      132.69
142.99


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.
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx put =
'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //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@xxxxxxxxxxxxx put =
'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: