View sessions of different nodes in Oracle RAC

Problem description: My colleague said that an SQL statement on PLSQL has been being executed. To be disconnected, the PLSQL process cannot be disconnected. Therefore, the PLSQL process is simply closed. Later, I wanted to check whether the process was still running and found that the user was not authorized to view the session. So I used my own machine and another user to check the process. What I was wondering at this moment was, I have never been able to find the related session of that machine.

Cause: the node connected to the machine is different from that connected to me.

Another problem: Can I check the sessions of each node in an oracle cluster?

A: In the V $ session view, you can only view sessions under the node where the client is located. If you want to view sessions under all nodes, You need to view the GV $ session view. I have always used the V $ session view to view the sessions generated by the connected nodes and those machines that are different from me.

 

Thank you for your answers.