You are managing a tier-1 OLTP application on an Autonomous Transaction Processing (ATP) database. Your business needs to run hourly batch processes on this ATP database that may consume more CPUs…

Question

Options

• ACopy OLTP data into new tables in a new table space and run batch processes against these new
• BATP is designed for OLTP workload only; you should not run batch processes on ATP
• CDisable automated backup during the batch process operations
• DConfigure ATP resource management rules to manage runtime and IO consumption for the

• A
  13% (4)
• B
  6% (2)
• C
  3% (1)
• D
  77% (24)

Explanation

Autonomous Transaction Processing comes with predefined CPU/IO shares assigned to different consumer groups. You can modify these predefined CPU/IO shares if your workload requires different CPU/IO resource allocations. By default, the CPU/IO shares assigned to the consumer groups TPURGENT, TP, HIGH, MEDIUM, and LOW are 12, 8, 4, 2, and 1, respectively. The shares determine how much CPU/IO resources a consumer group can use with respect to the other consumer groups. With the default settings the consumer group TPURGENT will be able to use 12 times more CPU/IO resources compared to LOW, when needed. The consumer group TP will be able to use 4 times more CPU/IO resources compared to MEDIUM, when needed.

No community discussion yet for this question.