Oracle Database 12c: Installation and Administration — Question 3

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?

Answer options

• 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

Correct answer: B

Explanation

The correct answer is B, as the Database Resource Manager can be configured to manage session resources and terminate idle sessions that are blocking others. Option A does not specifically address session termination, C pertains to resumable sessions which is unrelated, and D focuses on limiting idle time but does not provide automatic termination for blocking sessions.