All,
Ned to the forum and lookforward 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 8s 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????? 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 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.
Ned to the forum and lookforward 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 8s 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????? 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 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.
