OraFAQ Forum: Server Administration » LISTENER consuming 95% CPU

Home » RDBMS Server » Server Administration » LISTENER consuming 95% CPU (Oracle 8.1.7 on HP-UX B.11.00)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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 1199 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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 17 00:04:53 CDT 2025