Re: 32nd Oracle Process Hangs
From: Doug Harris <ah513_at_FreeNet.Carleton.CA>
Date: Tue, 5 Apr 1994 22:33:38 GMT
Message-ID: <Cnt5C2.2MI_at_freenet.carleton.ca>
Date: Tue, 5 Apr 1994 22:33:38 GMT
Message-ID: <Cnt5C2.2MI_at_freenet.carleton.ca>
In a previous article, davidsonj_at_gtewd.mtv.gtegsc.com () says:
>I am running into a strange problem where attempts to log into Oracle hang.
>
>Monitoring the number of oracle processes shows that we consistently get this
>problem on the 32nd process.
Are you using the Multi-Threaded Server? If so, this behaviour is consistent with the dispatcher running out of file descriptors (one socket per session). Workaround is to either start more dispatchers or increase the file descriptor table with ulimit.
Other things to look for:
- Not enough system semaphores (unlikely as they are usually allocated when the instance starts up).
- Make sure that the init.ora parameter "sessions" is high enough. If you are expecting a maximum of "n" sessions then "sessions" should be (n * 1.1) if you are not using auditing, and (n * 2.1) if you are using auditing.
Good Luck!
- Doug Harris Database Administrator, System Development Division, Statistics Canada ## Standard Disclaimer Applies ## --