OCP-V13-690

1. 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. 执行数据库资源管理计划

Answer:D

答案是 D
防止资源的过度消耗:ODRM可以从session级别控制CPU、Undo等系统资源的过度消耗.通过定义使用比例
的方法防止CPU被某个session独占耗光;