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
youngb912
Messages: 56
Registered: October 2007
Location: New York
Member
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 1137 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: Fri Jul 12 19:54:12 CDT 2024