How would you accomplish this task?

You plan to control idle sessions that are blocking other sessions from performing transactions. Your
requirement is to automatically terminate these blocking sessions when they remain idle for a specified amount
of time.How would you accomplish this task?

You plan to control idle sessions that are blocking other sessions from performing transactions. Your
requirement is to automatically terminate these blocking sessions when they remain idle for a specified amount
of time.How would you accomplish this task?

A.
Set metric threshold

B.
Implement Database Resource Manager

C.
Enable resumable timeout for user sessions

D.
Add directives to Automatic Database Diagnostic Monitor (ADDM)



Leave a Reply 0

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