Database Utilities (MOSC)

MOSC Banner

RESOURCE_LIMIT License confusion

edited Jun 9, 2014 8:20AM in Database Utilities (MOSC) 6 commentsAnswered ✓

Hi,

We want to limit concurrent usersessions by creating and applying an user profile ( "CREATE PROFILE PRO SESSIONS_PER_USER 200" ).

To make it working, I have to set "RESOURCE_LIMIT=TRUE" too.

If I do that, does it enable the "Oracle Resource Manager" too, wich is an Enterprise Edition Feature, or is an userprofile something different as the "Oracle Resource Manager" (introduced with 10g)?

May I use a userprofile (not the Oracle Resource Manager) for example to limit users sessions in Oracle Standard Edition?

Regards and Thanks Peter

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center