Ryan
The situation you are encountering is not something unusual. The way i
have configure my databases (both Dev and PROD) is that, we limit the
database connectivity by two methods
1. Profile where we mention the no of sessions_per_user
-AND-
2. dbms_resource (cpu resource etc)
HTH
GovindanK
>
> ryan_gaffuri_at_comcast.net wrote:
>> 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?
> ryan_gaffuri_at_comcast.net
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Mar 15 2007 - 11:54:47 CDT
