How would you achieve this?

The database users regularly complain about the difficulty in performing transactions. On
investigation, you find that some users perform long-running transactions that consume huge
amounts of space in the undo tablespace, which caused the problem. You want to control
the usage of the undo tablespace only for these user sessions and you do not want these
sessions to perform long-running operations.
How would you achieve this?

The database users regularly complain about the difficulty in performing transactions. On
investigation, you find that some users perform long-running transactions that consume huge
amounts of space in the undo tablespace, which caused the problem. You want to control
the usage of the undo tablespace only for these user sessions and you do not want these
sessions to perform long-running operations.
How would you achieve this?

A.
Implement a profile for the users.

B.
Implement external roles for the users.

C.
Set the threshold for the undo tablespace.

D.
Implement a Database Resource Manager plan.



Leave a Reply 1

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

16 − 15 =


bs

bs

D is correct.

The resources that can be controlled by a plan are:

Volume of undo space permitted per group