Re: limit number of connections on oracle account

From: Ban Spam <ban-spam_at_operamail.com>
Date: Wed, 05 Sep 2001 00:57:32 GMT
Message-ID: <Xns9112B6B01B3DASunnySD@24.0.3.73>

ewong_at_mail.com (Ed Wong) wrote in
news:a5ae1554.0109041621.1a854f9f_at_posting.google.com:

> I like to know how to limit number of connections of an oracle
> account. I have an instance with three oracle accounts on it and it
> want to limit number of connections to, say 50, on one of the
> accounts. Any help is appreciated.
>
> Oracle 8.1.7.2.0 EE
>

One "simple" way & not necessarily the best would be to implement logon/logoff triggers that increment/decrement a value in a table. When the value hit the threshold, say 50, it terminates the session rather than allowing it to logon. The logoff trigger simply decrements the value.

HTH & YMMV! Received on Tue Sep 04 2001 - 19:57:32 CDT