Hi all,
I have one doubt about oracle wait events, specifically about "SQL*Net message from client". I've read a lot about it, I've seen some say that network and another physical resources may cause it, and I've seen that problems in application code can cause it too. I'm monitoring some tests here and I've that selects that are from dual generally cause a lot of SQL*Net message from client wait (I used sqlplus, sql developer and pl/sql). Can someone explain me why? Another question is where this type of wait cause interference, the database respond the request and stays waiting and do not respond to another request while the wait doesn't finish, is this? The wait just finish when the application close the database connection or there is another way to finish the wait?
Since then, very much thank you.