Database Administration (MOSC)

MOSC Banner

Can Oracle parameter RESOURCE_LIMIT and IDLE_TIME usage be used on Standard Edition?

in Database Administration (MOSC) 2 commentsAnswered ✓

We are using Oracle Standard Edition 19c and would like to explore options for removing sessions that are Inactive. One of the solutions we came across was to change Parameter: RESOURCE_LIMIT to TRUE. Our current configuration has this parameter set as FALSE.


Once RESOURCE_LIMIT is set to TRUE, create a profile and set the IDLE_TIME value and then add an entry into sqlnet.ora for SQLNET.EXPIRE_TIME.


If we use this configuration will we still be within our license for using Standard Edition?


Some documentation we found states that the RESOURCE_LIMIT parameter belongs to Resource Manager which is an Enterprise Edition option hence our reluctance to implement the above solution.

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

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center