My Oracle Support Banner

How to Create a Profile That Limits sessions_per_user (Doc ID 2426607.1)

Last updated on JUNE 25, 2024

Applies to:

Enterprise Manager Base Platform - Version 12.1.0.3.0 and later
Oracle Database - Enterprise Edition - Version 19.12.2.0.0 to 19.12.2.0.0 [Release 19]
Information in this document applies to any platform.
In some cases, database targets can get many sessions per user from the DBSNMP (monitor) user and that can cause performance issues on the database target server. This is a known issue that is documented in Doc ID 1559045.1.

If a patch cannot be applied, you can create a profile on the database which limits the sessions_per_user. Then assign the DBSNMP account to this profile.

Goal

Create a profile on the database which limits the sessions_per_user. Then assign the DBSNMP account to this profile.

Solution

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
Goal
Solution


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