Database Resource Manager directive UNDOPOOL - Oracle Tablespaces
Oracle (MCQ) questions and answers
Q. The Database Resource Manager directive UNDO_POOL allows DBAs to limit the amount of undo space consumed by a group of users.
- Published on 12 Aug 15
Oracle DBA (
Oracle Replication (
Oracle Architecture (
Oracle Transaction (
Administering and Managing an Oracle Database (
Managing Oracle Database Processes (
Oracle Control Files (
Oracle Redo Log (
Oracle Tablespaces (
Oracle Datafiles and Tempfiles (
Oracle Managed Files (
Oracle Schema (
Oracle Tables (
Oracle Indexes and Partitioned Tables (
Oracle Clusters (
Oracle Views, Sequences, and Synonyms (
Oracle Distributed Database concepts (
-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
Enter the code shown above:
(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)