Oracle OCP 1Z0 053 Q690(Resource Manager&Undo)

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

參考：https://docs.oracle.com/cd/E11882_01/server.112/e25494/dbrm.htm#ADMIN11855

Undo Pool

You can specify an undo pool for each consumer group. An undo pool controls the total amount of undo for uncommitted transactions that can be generated by a consumer group. When the total undo generated by a consumer group exceeds its undo limit, the current DML statement generating the undo is terminated. No other members of the consumer group can perform further data manipulation until undo space is freed from the pool.

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/8520577/viewspace-2075039/，如需轉載，請註明出處，否則將追究法律責任。