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:
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.
