How to set IDLE TIME in Oracle Database

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 […]

Read More