RE: RE: TKPROF output

From: D'Hooge Freek <Freek.DHooge_at_uptime.be>
Date: Thu, 31 Mar 2011 08:41:39 +0200
Message-ID: <4814386347E41145AAE79139EAA398981500A12D40_at_ws03-exch07.iconos.be>

True, but compaired to the time spend for sending the data it seems high. Also the max wait time is 1 second. It would be interesting to see the histogram for this.

Lyall,

Can you run orasrp on the raw trace file to get the histograms (http://www.oracledba.ru/orasrp/)

Remigiusz,

Thanks for the link, I will certainly check it out.

regards,

Freek D'Hooge
Uptime
Oracle Database Administrator
email: freek.dhooge_at_uptime.be
tel +32(0)3 451 23 82
http://www.uptime.be
disclaimer: www.uptime.be/disclaimer

From: Niall Litchfield [niall.litchfield_at_gmail.com] Sent: 31 March 2011 08:26
To: D'Hooge Freek; ORACLE-L
Subject: Re: RE: TKPROF output

Freek, I don't think the comms are slow per se. If my math is right the avg wait is 3ms . There are a lot of them though. Of course we don't know rowsize or what the original system looks like. On 31 Mar 2011 07:03, "D&apos;Hooge Freek" <Freek.DHooge_at_uptime.be> wrote:

Hi,

The main wait time is "sql*net message from client", meaning that you are waiting on response from the aplication server. Can you check in the raw trace file if these waits are happening between the fetches or not?

If they are happening between the fetches, it means that the application server is slow to request more rows from the query result. Reason for this could be some processing that happens on the application server or maybe a network problem (like a wrong dns server on the application server).

If the waits are happening after all the fetches are completed, then these waits are probably not relevant (unless you are sure that the trace was stopped at the moment the application showed the result of the query). How did you trace this session?

regards,

Freek D'Hooge
Uptime
Oracle Database Administrator
email: freek.dhooge_at_uptime.be
tel +32(0)3 451 23 82
http://www.uptime.be
disclaimer: www.uptime.be/disclaimer

---
From: oracle-l-bounce_at_freelists.org [oracle-l-bounce_at_freelists.org] On Behalf Of lyallbarbour_at_sanfranmail.com [lyallbarbour_at_sanfranmail.com]
Sent: 30 March 2011 20:55

To: oracle-l_at_freelists.org
Subject: TKPROF output


Trying to understand Fetch in a TKPROF output. We have an application on Oracle Apps Server 10.1 D...
 SQL*Net message from client                 27457        1.07        100.33--

http://www.freelists.org/webpage/oracle-l--
http://www.freelists.org/webpage/oracle-l

Received on Thu Mar 31 2011 - 01:41:39 CDT