irukulla
asked on
What kind of wait event is this in Oracle
Hi, when i am looking at my wait event on my systems, there are many SID, with the same wait event "SQL*Net Message from Client".
Can anybody tell me, what is causing this wait event?
Can anybody tell me, what is causing this wait event?
johnsone
Typically that message would be for a session that is waiting for the client machine to issue a query. It is not a problem.
That event belongs to the class of "Idle Events", i.e. what a session says it's waiting on when it's idling. This query will give you all of them, they can be safely ignored on most cases:
select * from v$event_name where wait_class='Idle' order by name
select * from v$event_name where wait_class='Idle' order by name
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
None
why the B?
That is a penalty grade, please don't close questions with penalties without first giving the participants a chance to fulfill whatever requirement you thought was lacking
That is a penalty grade, please don't close questions with penalties without first giving the participants a chance to fulfill whatever requirement you thought was lacking