Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: limit number of connections on oracle account
Use resource limiting. You need to set an inti.ora parameter and set a
limit on the number of connections for an account. Default is unlimited.
One caveate is that if the client connection terminates unexpectedly it can
take awhile for Oracle to detect it. Thus the 51st person might have a
little trouble even if someone turned off their PC.
Jim
"Ed Wong" <ewong_at_mail.com> wrote in message
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
Received on Wed Sep 05 2001 - 00:09:54 CDT