Re: SQL*Net message from client high wait time

Posted by ErmanArslansOracleBlog on Feb 16, 2023; 7:14am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/SQL-Net-message-from-client-high-wait-time-tp11606p11607.html

It is an idle event.
It is related with the shadow process that is waiting for a message to arrive from the client process.
It seems no db links involved there.. Just an OBJ$ query.

Yes..  What is the client? A monitoring tool or something? What does it do with the obj$.. Check the client and understand why it is waiting.. (another transaction, some input from somewhere and so on..)

That is related with the client is waiting for input.. That 's time in the client process itself ,
That 's also the time in the network between the client and the server. SQL*Net trace (with TIMESTAMPS) can be helpful to check the network between the client and server.