Home » RDBMS Server » Server Administration » LISTENER consuming 95% CPU (Oracle 8.1.7 on HP-UX B.11.00)
icon5.gif  LISTENER consuming 95% CPU [message #352220] Mon, 06 October 2008 12:13
Messages: 49
Registered: October 2007
Location: New York
Recently we started to notice performance degradation while users are attempting to connect to the database. Issue is now resolved but this where my findings in the process -

1. Firstly tnslsnr is consuming 95% of my CPU.

2. Also there appear to be two Oracle listener running on my PROD server. I stop one of the listener and users where unable to connect to the database using ODBC until I restarted it. It seems that I must have two listeners before they can connect using ODBC. Other users of other applications are fine except people using the ODBC.

How do I determine while the listener is consuming 95% CPU?
  • Attachment: listener.txt
    (Size: 2.86KB, Downloaded 244 times)

[Updated on: Mon, 06 October 2008 12:22]

Report message to a moderator

Previous Topic: sga_max_size - how to find the max value for AIX 5L
Next Topic: Synonym For Procedure
Goto Forum:

Current Time: Wed Jul 26 06:07:59 CDT 2017

Total time taken to generate the page: 0.12665 seconds