How would you avoid the issue from repeating in future?

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

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.



Leave a Reply 0

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