| Looking for a guru [message #209424] |
Thu, 14 December 2006 14:46  |
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 #209432 is a reply to message #209426] |
Thu, 14 December 2006 15:15  |
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????
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
