How to set IDLE TIME in oracle Database

1- connect as sysdba user

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

2- 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’);  2    3
 
SQL> /
PROFILE                        RESOURCE_NAME                    RESOURCE LIMIT
—————————— ——————————– ——– —————————————-
DEFAULT                        IDLE_TIME                        KERNEL   UNLIMITED    
DEFAULT                        CONNECT_TIME                     KERNEL   UNLIMITED
SQL>
 

3- 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’);   2    3
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.
 

About Sher khan

Senior Oracle DBA, Oracle 10g and 11g OCE and OCS, Oracle 11g OPN certified Specialist, OCP Certified in Oracle 9i,10g and 11g. I am working in Oracle technology since 2004. Currently working in U.A.E Email: sher487@hotmail.com
This entry was posted in Database administration. Bookmark the permalink.

One Response to How to set IDLE TIME in oracle Database

  1. Terry Kendall says:

    Thanks for the clear explanation and directions.
    Great Stuff..

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s