Database Resource Manager directive UNDOPOOL - Oracle Tablespaces

Discussion

• Nirja Shah   -Posted on 31 Aug 15
  - The Oracle Database Resource Manager can be used to establish user quotas for undo space.
  
  - The Database Resource Manager directive UNDO_POOL allows DBAs to limit the amount of undo space consumed by a group of users (resource consumer group).
  
  - You can specify an undo pool for each consumer group.
  
  - An undo pool controls the amount of total undo that can be generated by a consumer group.
  
  - When the total undo generated by a consumer group exceeds its undo limit, the current UPDATE transaction generating the undo is terminated.
  
  - No other members of the consumer group can perform further updates until undo space is freed from the pool.
  
  - When no UNDO_POOL directive is explicitly defined, users are allowed unlimited undo space.

➨ Post your comment / Share knowledge