1Z0-062 · Question #246
You want to prevent a group of users in your database from performing long-running transactions that consume huge amounts of space in the undo tablespace. If the quota for these users is exceeded…
The correct answer is D. Implement a Database Resource Manager plan. To prevent a group of users from consuming excessive undo tablespace during DML operations while still allowing queries, an Oracle Database Resource Manager plan should be implemented.
Question
You want to prevent a group of users in your database from performing long-running transactions that consume huge amounts of space in the undo tablespace. If the quota for these users is exceeded during execution of a data manipulation language (DML) statement, the operation should abort and return an error. However, queries should still be allowed, even if users have exceeded the undo space limitation. How would youachieve this?
Options
- ASpecify the maximum amount of quota a user can be allocated in the undo tablespace.
- BDecrease the number of Interested Transaction List (ITL) slots for the segments on which these
- CImplement a profile for these users.
- DImplement a Database Resource Manager plan.
How the community answered
(13 responses)- A8% (1)
- C15% (2)
- D77% (10)
Why each option
To prevent a group of users from consuming excessive undo tablespace during DML operations while still allowing queries, an Oracle Database Resource Manager plan should be implemented.
Specifying a quota usually restricts the overall space a user can allocate for segments (tables, indexes) within a tablespace, not the undo space consumed by transactions.
Decreasing Interested Transaction List (ITL) slots primarily affects concurrency on data blocks and can cause errors during high concurrent DML, but it does not directly limit total undo space consumption for a transaction.
Oracle profiles primarily set limits on session-level resources like CPU time, logical reads, or idle time, but they do not directly control or limit undo tablespace consumption for transactions.
Oracle Database Resource Manager (DBRM) allows you to define resource plans with directives like `UNDO_POOL` that limit the undo tablespace consumption for specific consumer groups. If the limit is exceeded during a DML operation, the transaction will abort and return an error, while queries are unaffected.
Concept tested: Oracle Database Resource Manager for undo limits
Source: https://docs.oracle.com/en/database/oracle/oracle-database/21/admin/managing-resources-with-oracle-database-resource-manager.html#GUID-382C1014-9989-49F1-8083-B75B26A49F86
Topics
Community Discussion
No community discussion yet for this question.