Re: Profile limit concurrent sessions for a user not limiting as expected

It certainly sounds wrong. Have you (if you're allowed) checked what happens if you try to get 3 SQL*Plus (or similar) sessions with direct connections. I'm wondering if it's something to do with connection pooling (are the other two sessions still alive, or has one of them - for example - been flagged in v$session as "sniped"), or maybe something to do with the way that the application code handles exceptions and the connect mechanism it uses. Are the three sessions (v$sessions) associated with three difference processes (v$process), or has one process managed to spawn multiple sessions - maybe something like that could bypass the profile limit.

Regards
Jonathan Lewis

On Wed, 17 Jan 2024 at 02:58, Jack van Zanen <jack_at_vanzanen.com> wrote:

> Hi
>
>
> We have an application and want to limit the number of sessions a user can
> open so are experimenting with the profile and setting "Concurrent
> sessions(Per user)" set to 2
>
> When I start the application I can see one session, so far so good. I can
> start another one and that works fine too..However on the third one is
> where things do not behave as I expected. I correctly get the pop up that
> the sessions have exceeded the value for concurrent max sessions. But when
> I click "ok" I get an application logon error popup. When I click that it
> starts a third session and logs into the application just fine and leaves
> me with 3 working sessions in the database for my username. I was hoping to
> get just the error popup and that would be it.
>
> Can anyone explain under what conditions does oracle allow me to have 3
> sessions when my max is set to 3?
>
> database 12.2
>
> Regards
>
>
> Jack van Zanen
>
>
> -------------------------
> This e-mail and any attachments may contain confidential material for the
> sole use of the intended recipient. If you are not the intended recipient,
> please be aware that any disclosure, copying, distribution or use of this
> e-mail or any attachment is prohibited. If you have received this e-mail in
> error, please contact the sender and delete all copies.
> Thank you for your cooperation
>

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