Home » Infrastructure » Windows » TNSLSNR.EXE consuming High Memory (Windows 2003, Oracle11g)
TNSLSNR.EXE consuming High Memory [message #502986] Tue, 12 April 2011 02:28 Go to next message
pradies
Messages: 250
Registered: May 2008
Senior Member
Hi,

I am using Oracle 11g On windows 2003 Server, and in the task manager, tnslsnr.exe comsuming approx 1 GB of RAM. After restarting the listener it came to some mb(20-30). but Again after few days it raies and consume lots of memory.

Kindly tell me why this is coming and what is the solution of this.

Thanks and Regards

Pradeep

Attachment :: screen shot of task manger.

[EDITED by LF: fixed topic title typo; was "tnslsnE.exe" and "coMsuming"]
  • Attachment: untitled.PNG
    (Size: 17.56KB, Downloaded 1395 times)

[Updated on: Tue, 12 April 2011 04:42] by Moderator

Report message to a moderator

Re: TNSLSNR.EXE comsuming High Memory [message #503007 is a reply to message #502986] Tue, 12 April 2011 04:15 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
How does your LISTENER.ORA look like?
Re: TNSLSNR.EXE comsuming High Memory [message #503008 is a reply to message #503007] Tue, 12 April 2011 04:18 Go to previous messageGo to next message
pradies
Messages: 250
Registered: May 2008
Senior Member
Hi Littlefoot,

I am uploading my listener.ora file.....

Regards

Pradeep
  • Attachment: listener.ora
    (Size: 0.72KB, Downloaded 1694 times)
Re: TNSLSNR.EXE comsuming High Memory [message #503109 is a reply to message #503008] Wed, 13 April 2011 01:28 Go to previous messageGo to next message
pradies
Messages: 250
Registered: May 2008
Senior Member
Hi ,

I am facing the same issue on another server. I am uploading screen shot and listener.ora file for the server.

Please help.


Pradeep
  • Attachment: listener.ora
    (Size: 0.72KB, Downloaded 1626 times)
Re: TNSLSNR.EXE comsuming High Memory [message #503110 is a reply to message #503109] Wed, 13 April 2011 01:29 Go to previous messageGo to next message
pradies
Messages: 250
Registered: May 2008
Senior Member
screen shot for above server
  • Attachment: untitled.PNG
    (Size: 31.97KB, Downloaded 1338 times)
Re: TNSLSNR.EXE comsuming High Memory [message #503120 is a reply to message #503110] Wed, 13 April 2011 02:12 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I'm afraid I can't help much. From what I read, people have had such problems when there were many parameters in LISTENER.ORA. Yours seem to be OK (as far as I can tell, and that's really not much).
Re: TNSLSNR.EXE comsuming High Memory [message #503155 is a reply to message #503120] Wed, 13 April 2011 04:43 Go to previous messageGo to next message
jayraj
Messages: 11
Registered: January 2011
Location: Mumbai
Junior Member
Pl. check a size of "D:\app\Administrator\product\11.1.0\db_1\network\log\listener.log" file. Re-initialize that file if large in size. Also send "sqlnet.ora" file.


Brgds,

Sanjay
Re: TNSLSNR.EXE comsuming High Memory [message #503156 is a reply to message #503155] Wed, 13 April 2011 04:48 Go to previous messageGo to next message
pradies
Messages: 250
Registered: May 2008
Senior Member
Hi Jay,

In the first case Listener_logging is off. So there is no listener.log file. sqlnet.ora file attached

Regards

Pradeep
  • Attachment: sqlnet.ora
    (Size: 0.45KB, Downloaded 1634 times)
Re: TNSLSNR.EXE comsuming High Memory [message #503205 is a reply to message #503156] Wed, 13 April 2011 08:47 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

post details inline as part of thread & not as attachments
Re: TNSLSNR.EXE comsuming High Memory [message #503211 is a reply to message #503205] Wed, 13 April 2011 10:01 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Release 11.1.0.6? If so, bug 6998054 may be your problem.
Re: TNSLSNR.EXE comsuming High Memory [message #503296 is a reply to message #503211] Thu, 14 April 2011 04:21 Go to previous messageGo to next message
pradies
Messages: 250
Registered: May 2008
Senior Member
Hi John,

Thanks for revert back. one more thing please tell me if I have another database with same release but there I am not getting the same issue. So is any special environmental/parameter setting thats why we are getting the problem there..?


Regards

Pradeep
Re: TNSLSNR.EXE comsuming High Memory [message #503306 is a reply to message #503296] Thu, 14 April 2011 04:36 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
See bug description on Metalink.

Regards
Michel
Previous Topic: Oracle Client and Windows 7 64 Bits
Next Topic: Connect a client Oracle 64 bits to a db 64 bits.
Goto Forum:
  


Current Time: Thu Mar 28 15:59:29 CDT 2024