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.
 
Advertisements

About Sher khan

Senior Oracle DBA, Oracle 10g , Oracle 11g OCE ,Oracle 12C and Oracle 11g OPN certified Specialist, OCP Certified in Oracle 9i,10g , 11g and 12C. 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