Limiting conn. with SESSIONS_PER

From: Pepin <sbourque_at_my-deja.com>
Date: Fri, 30 Jul 1999 17:15:46 GMT
Message-ID: <7nsmjn$nij$1@nnrp1.deja.com>

We are hosting web applications and Oracle DBs from external clients. I thought that by creating a profile for each of these clients, I could limit the resources they use, especially the number of connection.

Problem is, even if I specify SESSIONS_PER_USER=5 in one user's profile, he can have many more connections, but with the status "INACTIVE". Are those inactive connections counting in the SESSIONS_PER_USER number? If not, what can I do to get rid of those connections and avoid any new connection beyond the specified number other than using IDLE_TIME.

Thanks in advance!

--
Stephane Bourque
Oracle DBA / Programmer-Analyst
up2 technologies inc. - a subsiduary of Teleglobe inc. Tl +1 514 868 7680 / Fx +1 514 868 7212

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Fri Jul 30 1999 - 12:15:46 CDT

Limiting conn. with SESSIONS_PER_USER?