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
