CONNECT_TIME and IDLE_TIME in Oracle profile

CONNECT_TIME and IDLE_TIME in Oracle profile

CONNECT_TIME: Parameter will disconnect a session whose connect time exceed the value for connect_time.The connect_time is expressed in minutes.

IDLE_TIME: Permitted periods of continuous inactive time during a session(minutes).
We specify 10 minutes as the parameter value, the user session expires after 11 minutes or 12 minutes.
PMON background process periodically checks the user sessions for idle time out.

DBA_PROFILES view provides information on all the profiles and the resource limits for each profile.
Each user can find information on his resources and limits in the USER_RESOURCE_LIMITS view.

Check the idle time and connect time value for a profile

SELECT * FROM DBA_PROFILES WHERE PROFILE='DEFAULT' AND RESOURCE_NAME IN ('IDLE_TIME','CONNECT_TIME');

Alter value of idle time

ALTER PROFILE DEFAULT LIMIT IDLE_TIME UNLIMITED;

Alter value of connect time

ALTER PROFILE DEFAULT LIMIT CONNECT_TIME UNLIMITED;

For using resource limit parameter should be true

SHOW PARAMETER RESOURCE_LIMIT;

--for alter resource limit parameter
ALTER SYSTEM SET RESOURCE_LIMIT=TRUE SCOPE=BOTH;

Default is true.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.