For your database some users complain about not being able to execute transactions. Upon investigation, you find that the problem is caused by some users performing long-running transactions that consume huge amounts of space in the UNDO tablespace.
You want to control the usage of the UNDO tablespace only for these user sessions.
How would you avoid the issue from repeating in future? (Choose the best answer.)
- A: Create a profile for the users with the LOGICAL_READS_PER_SESSION and LOGICAL_READS_PER_CALL limits defined.
- B: Create external roles to restrict the usage of the UNDO tablespace and assign them to the users.
- C: Set the threshold for UNDO tablespace usage for the users.
- D: Implement a Database Resource Manager plan by mapping the users to a resource consumer group with limits defined for UNDO tablespace usage.