Managing Oracle Profile Settings: CONNECT_TIME & IDLE_TIME

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 for profile in Oracle

ALTER PROFILE DEFAULT LIMIT IDLE_TIME UNLIMITED;

Alter value of connect time for Profile in Oracle

ALTER PROFILE DEFAULT LIMIT IDLE_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.