In your database, you want to ensure that idle sessions that are blocking active are automatically terminated
after a specified period of time.
How would you accomplish this?
Setting a metric threshold
Implementing Database Resource Manager
Enabling resumable timeout for user sessions
Decreasing the value of the IDLE_TIME resource limit in the default profile
An Oracle session is sniped when you set the idle_time parameter to disconnect inactive sessions. (It’s only like
sniping on ebay in that a time is set for an action to occur.)
Oracle has several ways to disconnect inactive or idle sessions, both from within SQL*Plus via resources
profiles (connect_time, idle_time), and with the SQL*net expire time parameter. Here are two ways to
disconnect an idle session:
Set the idle_time parameter in the user profile
Set the sqlnet.ora parameter expire_time