How would you accomplish this?

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?

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



Leave a Reply 3

Your email address will not be published. Required fields are marked *