Solved

What kind of wait event is this in Oracle

Posted on 2011-03-18
5
827 Views
Last Modified: 2012-06-27
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?
0
Comment
Question by:irukulla
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
5 Comments
 
LVL 35

Expert Comment

by:johnsone
ID: 35167798
Typically that message would be for a session that is waiting for the client machine to issue a query.  It is not a problem.
0
 
LVL 11

Expert Comment

by:Akenathon
ID: 35168312
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
0
 
LVL 74

Accepted Solution

by:
sdstuber earned 500 total points
ID: 35170319
The above comments about it being an "idle" wait is true,  seeing it doesn't necessarily mean you don't have a problem though.

Check the wait times and number of waits.  If the wait times are small but you see lots and lots of waits that means your client is issuing many small calls to the db.
It's possible you should change the processing to do fewer but larger calls in order to improve total throughput.

Also, if you see large times for that wait it means your database is waiting for your client to do something, which could because the user is sitting there reading the screen and thinking and maybe got up and walked away,  it could also mean there is processing happening on the client which is taking a long time.  Your database can't help that processing go faster but seeing that wait "could" be an indication that the client code is inefficient
0
 

Author Closing Comment

by:irukulla
ID: 35172881
None
0
 
LVL 74

Expert Comment

by:sdstuber
ID: 35173974
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
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Suggested Courses

623 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question