Re: orasrp SQL*Net message to client as non-idle event

From: Karl Arao <karlarao_at_gmail.com>
Date: Sun, 7 Feb 2010 09:03:04 +0800
Message-ID: <12ee65601002061703g55d46a13yb22e0246fe124cdb_at_mail.gmail.com>

Cool ! :) the pictures behind the words really help to grasp the idea behind *SQL*Net events.*
*With this you get a good visual distinction... which provides better understanding of course.. *

**- Karl Arao
karlarao.wordpress.com

On Sun, Feb 7, 2010 at 4:40 AM, kyle Hailey <kylelf_at_gmail.com> wrote:

>
> Check out
>
>
> http://sites.google.com/site/embtdbo/wait-event-documentation/oracle-network-waits
>
>
> <http://sites.google.com/site/embtdbo/wait-event-documentation/oracle-network-waits>"SQL*Net
> message to client' is not an idle event, it's a the time it takes pack a
> message for the network. Tanel Poder has a great write up on it at
> http://blog.tanelpoder.com/2008/02/10/sqlnet-message-to-client-vs-sqlnet-more-data-to-client/
> If orasrp is calling "SQL*Net message to client" an idle event it makes me
> wonder if they are getting it confused with "SQL*Net message from client"
> which can rolls up time that can be idle, network or work (as in
> application processing time)
>
> orasrp looks cool. I'll have to check it out! I'd heard about a 10046
> analyzer from Russia but hadn't tracked it down. This orasrp must be it.
>
> For system load modeling and analysis, check out DB Optimizer:
>
> http://sites.google.com/site/embtdbo/wait-event-documentation/database-tuning
>
> Best
> Kyle Hailey
> http://db-optimizer.blogspot.com/
>

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

Received on Sat Feb 06 2010 - 19:03:04 CST