We have a 2 node RAC. Local and remote listeners are configured on both nodes. I read somewhere that when a node is over-loaded, the local listener routes new client connection requests to remote listener.
My questions are:
1. Is my understanding correct?
2. If my understanding is correct, how can I find connections that were made initially to listener (local listener) of node 1 but redirected later to listener (remote listener) of node 2?