Prev Question
Next Question

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

Prev Question
Next Question

Leave a Reply

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