Today we are going to explore the steps which we use for set IDLE TIME in Oracle Database.  Let’s follow the steps.

Step1:- connect as sysdba user

SQL> conn /as sysdba
SQL> sho parameter resource_limit
NAME TYPE VALUE
———————————— ———– ——————————
resource_limit boolean FALSE

Step2:- Change the resource parameter to true

SQL> alter system set resource_limit=TRUE scope=both;
System altered.
SQL> select * from dba_profiles where profile='DEFAULT' and resource_name in (‘IDLE_TIME’,’CONNECT_TIME’);

PROFILE RESOURCE_NAME RESOURCE LIMIT
—————————— ——————————– ——– —————————————-
DEFAULT IDLE_TIME KERNEL UNLIMITED
DEFAULT CONNECT_TIME KERNEL UNLIMITED
SQL>

Step3:- Change the IDLE time to 60min

SQL> ALTER PROFILE DEFAULT LIMIT IDLE_TIME 60;
Profile altered.
SQL> select * from dba_profiles where profile=’DEFAULT’ and resource_name in (‘IDLE_TIME’,’CONNECT_TIME’);
PROFILE RESOURCE_NAME RESOURCE LIMIT
—————————— ——————————– ——–
DEFAULT IDLE_TIME KERNEL 60
DEFAULT CONNECT_TIME KERNEL UNLIMITED
SQL>

It is changed to 60 min of idle time. The application will disconnect if it is idle for 60.

Today’s thought 

“Practice kindness all day to everybody and you will realize you’re already in heaven now.”– Jack Kerouac

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

Joel Perez’s LinkedIn: Joel Perez’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp

About The Author

Leave a Reply

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