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

I think it is because the limit is per node and I have a 2 node RAC so setting it to 2 actually limits the user to 4 setting this to 1 limits them to 2.

Need to do some more testing, but that is what I think is happening

Jack van Zanen

> 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