My Oracle Support Banner

SESSIONS_PER_USER In a Profile Not Working As Expected. Allows more sessions intermittently than the specified profile limit (Doc ID 3066868.1)

Last updated on JANUARY 09, 2025

Applies to:

Oracle Database - Enterprise Edition - Version 19.21.0.0.0 and later
Information in this document applies to any platform.

Symptoms

This issue is related to the use of profile limit parameter SESSIONS_PER_USER.

While trying to limit the number of "active + inactive" sessions for a particular user using the profile limit parameter SESSIONS_PER_USER, but it's not working as user is still allowed to make more connections than defined in this limit. behavior is intermittent and can be reproduced when active sessions are executing a long running query.

Changes

 No change. Requirement is to have limit enabled for user sessions.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.