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?
A.
Setting a metric threshold
B.
Implementing Database Resource Manager
C.
Enabling resumable timeout for user sessions
D.
Decreasing the value of the IDLE_TIME resource limit in the default profile
Explanation:
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
B
MAX_IDLE_BLOCKER_TIME
http://docs.oracle.com/database/121/ADMIN/dbrm.htm#ADMIN11868
B
B