nerdexam
Oracle

1Z0-060 · Question #122

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?

The correct answer is B. Implementing Database Resource Manager. IDEL_TIME is about generic idle time limit, not specifically blocking sessions. But question is about idle sessions blocking other sessions Limit the amount of time that a session can be idle. This can be further defined to mean only sessions that are blocking other sessions.

New Features for Performance

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?

Options

  • ASetting a metric threshold
  • BImplementing Database Resource Manager
  • CEnabling resumable timeout for user sessions
  • DDecreasing the value of the IDLE_TIME resource limit in the default profile

How the community answered

(25 responses)
  • A
    8% (2)
  • B
    76% (19)
  • C
    12% (3)
  • D
    4% (1)

Explanation

IDEL_TIME is about generic idle time limit, not specifically blocking sessions. But question is about idle sessions blocking other sessions Limit the amount of time that a session can be idle. This can be further defined to mean only sessions that are blocking other sessions.

Topics

#Database Resource Manager#idle session termination#blocking sessions#resource plan

Community Discussion

No community discussion yet for this question.

Full 1Z0-060 Practice