You are managing a tier-1 OLTP application on an Oracle Autonomous Transaction Processing (ATP) database. Your business needs to run hourly batch processes on this ATP database that may consume more CPUs than what is available on the server.
How can you limit these batch processes to not interfere with the OLTP transactions?
Select an option, then click Submit answer.
-
○
Configure ATP resource management rules to change CPU/IO shares for the consumer group of batch processes.
-
○
Copy OLTP data into new tables in a new table space and run batch processes against these new tables.
-
○
Disable automated backup during the batch process operations.
-
○
ATP is designed for OLTP workload only, you cannot run batch processes on ATP.