Home -> Mailing Lists -> Oracle-L -> RE: SQL*Net message from Client vs SQL*Net message from Client [idle]

RE: SQL*Net message from Client vs SQL*Net message from Client [idle]

From: <Christopher.Taylor2_at_parallon.net>
Date: Tue, 16 Apr 2013 08:51:46 -0500
Message-ID: <F05D8DF1FB25F44085DB74CB916678E8879BEE9C5E_at_NADCWPMSGCMS10.hca.corpad.net> 





HEH.  Good catch Sayan.  I should RTFM it seems LOL



Yes it was OraSRP, I didn't realize he was extrapolating that out that way.  I thought it was coming straight from the trc file and should have double checked.



Chris




-----Original Message-----



From: Sayan Sergeevich Malakshinov [mailto:malakshinovss_at_psbank.ru] 
Sent: Tuesday, April 16, 2013 8:49 AM


To: Taylor Christopher - Nashville


Cc: oracle-l_at_freelists.org


Subject: Re: SQL*Net message from Client vs SQL*Net message from Client [idle]



I think you need to specify that it was output of OraSRP (i googled it by "Session Flat Profile"). 
From readme of this tool (http://www.oracledba.ru/orasrp/README.html):



There are some wait events called 'idle wait events' (or in terms of 10g and above, events from class 'Idle events'). It's such events like 'SQL*Net message from client' or 'SQL*Net message from dblink'. But in terms of OraSRP they are not always 'idle'. They are 'idle' when they happens 'between-call'. For example, the following 'SQL*Net message from client' is considered 'idle': 




Best regards,


Sayan Malakshinov



--



http://www.freelists.org/webpage/oracle-l
Received on Tue Apr 16 2013 - 15:51:46 CEST












Original text of this message