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.
答案:(D)
解析:
使用资源管理计划可以实现某些用户使用资源的控制,包括undo表空间的使用空间
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/17013648/viewspace-1346731/ ,如需转载,请注明出处,否则将追究法律责任。