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

  • From: <Christopher.Taylor2@xxxxxxxxxxxx>
  • To: <malakshinovss@xxxxxxxxx>
  • Date: Tue, 16 Apr 2013 08:51:46 -0500

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@xxxxxxxxx] 
Sent: Tuesday, April 16, 2013 8:49 AM
To: Taylor Christopher - Nashville
Cc: oracle-l@xxxxxxxxxxxxx
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

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


Other related posts: