Detecting "dead connections" and disconnecting
Oracle sessions in performed in two places, the PMON process, and
via SQL*Net, by the sqlnet_expire_time
parameter.
* User Idle_Time -
select profile from dba_users where username='XXXXX'
select profile, resource_name, limit from dba_profiles where profile='YYYYY' and
resource_name ='IDLE_TIME'
* Source: http://www.runningoracle.com/product_info.php?products_id=318
How to make an idle session get SNIPED
You must set:
A. the initialization parameter resource_limit = TRUE in the init.ora
alter system set resource_limit=TRUE scope=both;
B. idle_time in the user profile
then you setup idle sessions to become sniped after x minutes.
With the following example the user session becomes sniped after 8 hours of idle time.
alter profile DEFAULT set idle_time=480;
* Source:http://www.programering.com/a/MzN2QzMwATI.html
ORACLE database INACTIVE, KILLED, ACTIVE, CACHED, SNIPED five kinds of state.
