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
B is the answer.
https://docs.oracle.com/database/121/ADMIN/dbrm.htm#ADMIN027
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.
Idle Time Limit
You can specify an amount of time that a session can be idle, after which it is terminated. You can also specify a more stringent idle time limit that applies to sessions that are idle and blocking other sessions
It cannot be D because not all the users have the default profil as their profil.
A user can have an other profile as his default profil. So it won't have effect on that user.
So i think the answer is B
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
khan
Highly Voted 5 years, 8 months agoSADIO
Highly Voted 3 years, 1 month agoPhoenix22
Most Recent 4 years, 8 months agosoniat
3 years, 9 months agoMamlouk_Med
5 years, 9 months agordnkrkmz
5 years, 11 months ago