How to set IDLE TIME in oracle Database

          How to set IDLE TIME in oracle Database(Step By Step)

1)    connect as sysdba user

                sqlplus “/as sysdba””

               show parameter resource_limit

              NAME                                 TYPE        VALUE

              ———————————— ———– ——————————

              resource_limit                       boolean     FALSE

           2)  Change the resource parameter to true

               alter system set resource_limit=TRUE scope=both;

              System altered.

            3) Check the idle time.

                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

          4) Change the IDLE time to 60min

              ALTER PROFILE DEFAULT LIMIT IDLE_TIME 60;

             Profile altered.

             5) Again Check the idle time.

         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