Home » RDBMS Server » Performance Tuning » Looking for a guru
Looking for a guru [message #209424] Thu, 14 December 2006 14:46 Go to next message
rvgriff
Messages: 3
Registered: December 2006
Location: Ft. Collins, CO
Junior Member

All,
New to the forum and look forward to getting and sharing info! I am pretty new to Oracle so please forgive my ignorance in advance. I am a global support specialist and several of my customers are seeing some very high load averages on theis UNIX servers running Oracle 10g. They are seeing 0.01 idle and the load averages are in the 8's across the board. The system runs along fine until a big query hits and it brings the system to a crawl.
My "support" has told me that this is due to the fact that 10G allows for unlimited threads to the database and 10g is designed to run this way. OK but I'm not completely buying it.....that is why I am coming to you folks! I am also seeing a ton of :
"WARNING: inbound connection timed out (ORA-3136)"
in the alerts.log
I am wondering if the two may be related in the fact that the queries are using threads and not releasing them so the loads stay maxxed out until the threads timeout????? I have read that this could also be due to the fact that 10g now has a port range for "dedicated connections". The servers that query the database directly in my system use :1521 and pass the info off to the clients throught the system. Wondering if someone can elaborate on this if at all possible. Looking for any hints or ideas that can help bring this to a close! Thank you all for becoming my shared support and look forward to the replies.
Re: Looking for a guru [message #209426 is a reply to message #209424] Thu, 14 December 2006 15:04 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Seems this issue is pretty much documented over Oracle support sites at metalink.oracle.com.
Please refer metalink note 345197.1 (which is less than a month old).
Regards~
Re: Looking for a guru [message #209432 is a reply to message #209426] Thu, 14 December 2006 15:15 Go to previous messageGo to next message
rvgriff
Messages: 3
Registered: December 2006
Location: Ft. Collins, CO
Junior Member

Well here is my issue...Only my "support", I'm using that term losely from this point forward, has access to metalink due to the service agreement between Oracle and my company. They are not helping so I'm trying to do whats right for my customers. If you could possibly convey the info to me I would greatly appreciate it! Unless you know of a way for me to access metalink info without a metaling login????
Re: Looking for a guru [message #209433 is a reply to message #209424] Thu, 14 December 2006 15:20 Go to previous messageGo to next message
BlackSwan
Messages: 25045
Registered: January 2009
Location: SoCal
Senior Member
You can make those log enties go away by adding
INBOUND_CONNECT_TIMEOUT_LISTENER = 0
to listener.ora
IMO, they are an annoyance & NOT the cause or effect of any performance issue you are having.
Re: Looking for a guru [message #209434 is a reply to message #209433] Thu, 14 December 2006 15:21 Go to previous messageGo to next message
rvgriff
Messages: 3
Registered: December 2006
Location: Ft. Collins, CO
Junior Member

Thank you for the input! Razz
Re: Looking for a guru [message #209435 is a reply to message #209424] Thu, 14 December 2006 15:43 Go to previous message
BlackSwan
Messages: 25045
Registered: January 2009
Location: SoCal
Senior Member
Needless to say after changing listener.ora, bounce the listener.
Previous Topic: DBF files
Next Topic: Windows vs Linux
Goto Forum:
  


Current Time: Wed Dec 07 20:32:38 CST 2016

Total time taken to generate the page: 0.11896 seconds