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

• AConfigure ATP resource management rules to change CPU/IO shares for the consumer group of
• BCopy OLTP data into new tables in a new table space and run batch processes against these new
• CDisable automated backup during the batch process operations.
• DATP is designed for OLTP workload only, you cannot run batch processes on ATP.

• A
  75% (21)
• B
  7% (2)
• C
  14% (4)
• D
  4% (1)

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.