How would you achieve this?

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 guota 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 you achieve this?
A. Specify the maximum amount of quota a user can be allocated in the undo tablespace
B. Decrease the number of Interested Transaction List (ITL) slots for the segments on which these users perform transactions
C. Implement a profile for these users.
D. Implement a Database Resource Manager plan

Download Printable PDF. VALID exam to help you PASS.

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.