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.)

Question

Accepted Answer

D. Implement a Database Resource Manager plan by mapping the users to a resource consumer

Answer

A. Create a profile for the users with the LOGICAL_READS_PER_SESSION and

Answer

B. Create external roles to restrict the usage of the UNDO tablespace and assign them to the users.

Answer

C. Set the threshold for UNDO tablespace usage for the users.

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…

Question

Options

How the community answered

Community Discussion