Listener consuming too much CPU resources!
Dear All,
My database is Oracle 11gR2, 2 Node RAC on Linux.
I have a strange problem on one of the node of my RAC.
The listener of one node i.e racnode 1 is consuming too much CPU resources and the response from the database becomes too slow. Even I feel enterprise manager working very slow. As soon as I stop the listener on this node. The database becomes efficient as it should be. I have tried a lot of things like restarting the server, delete automatic advisories and trying to efficient the application queries but nothing worked.
These are the contents of my listener.ora file:
LISTENER =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL=IPC)
(KEY=LISTENER)
)
)
)# lines added by Agent
LISTENER_SCAN1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL=IPC)
(KEY=LISTENER_SCAN1)
)
)
)# lines added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN1=ON # line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON # line added by Agent
Can you please suggest where from I can start the troubleshooting and what could be the reason for this issue. If you need any information please let me know.
Regards,
Imran