Which statement is true about a running session that belongs to the online transaction
processing (OLTP) group?
A.
It permanently switches to the low_group consumer group if the session exceeds 10,000
I/O requests or 2,500 MB of data transfer.
B.
It performs the first 10000 I/O requests or 2,500 MB of data transfer in the LOW-GROUP
consumer group, and then switches to the original group.
C.
It switches to the LOW_GROUP consumer group if the session exceeds 10000 I/O
requests or 2500 MB of data transfer and returns to the original group after the operation.
D.
It switches to the LOW_GROUP consumer group if the session exceeds 10000 I/O
requests or 2500 MB of data transfer for queries, but not for data manipulation language
(DML) operations.
Explanation:
Refer to here.Example 2
The following PL/SQL block creates a resource plan directive for the OLTP group that
temporarily switches any session in that group to the LOW_GROUP consumer group if the
session exceeds 10,000 I/O requests or exceeds 2,500 Megabytes of data transferred. The
session is returned to its original group after the offending top call is complete.
