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.
I think the correct answer is ‘C’. SWITCH_FOR_CALL parameter switches the session to its original consumer group after the top level call finishes in the ‘LOW_GROUP’
You are right. + SWITCH_IO_MEGABYTES limits both DSL and DML statements, thats why D is wrong.
http://docs.oracle.com/cd/E11882_01/server.112/e25494/dbrm.htm
Specifying Automatic Switching by Setting Resource Limits
http://docs.oracle.com/cd/E11882_01/server.112/e25494/dbrm.htm#ADMIN11881
“A top-level call in PL/SQL is an entire PL/SQL block treated as one call. A top-level call in SQL is an individual SQL statement.”
In that chapter there are also 3 examples. In 2 of them (1 and 3) it is written only about queries…
http://docs.oracle.com/cd/E11882_01/server.112/e17120/dbrm.htm#ADMIN027
SWITCH_IO_MEGABYTES:
Specifies the number of megabytes of I/O that a session can transfer (read and write) before an action is taken. Default is UNLIMITED. The action is specified by SWITCH_GROUP.