A session has been active for more than 20 hours, waiting for the event SQL * Net more data from client

Problem description:

A session has been active for more than 20 hours, waiting for the event SQL * Net more data from client

One session was logged on from eleven o'clock A.M. yesterday (v $ session. login_time), which has been ACTIVE till now, and there is only one SQL _id from v $ active_session_history, which is a merge operation, waiting for the event to be SQL * Net more data from client. There is no network problem. It is accessible now.

If SQL Execution is slow, it should not be the wait event.

 

Solution:

1. Search for the OS process id based on the session id

Select pid from v $ process where addr in (select paddr fromv $ session ');

 

2. Create an errorstack for the session and bring it up


Oradebug setospid xx;
Oradebug dump errorstack 3;
Oradebug tracefile_name;

 

Then, perform a specific analysis on tracefile to see if a bit of information can be found.