答复: too many session open and you can't log in?

two possibility
1. there is no more memory to spawn an process, to spawn an oracle process , we need to allocate some memory for pga and kernel process infomation. 2. the process or session has reached the session /process limit.

发件人: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] 代 表 ryan_gaffuri_at_comcast.net
发送时间: 2007年3月15日 9:14
收件人: oracle-l_at_freelists.org
主题: too many session open and you can't log in?

I had a problem last night where you could not log into sql plus. Seen this in cases where you bulk collect and do not use a limit clause and suck up too much memory.  

I noticed alot of sessions open at the time. Normally they are opened do a quick query and close. So I should see few open at any one time.  

is it possible to open so many sessions that you can't even log into oracle? I tried to kill -9 the sessions, but I believe I remember that this does not really kill the oracle sessions.  

how would you proceed if this happened again?

--
http://www.freelists.org/webpage/oracle-l