481.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.
Answer: D
参考:
http://docs.oracle.com/cd/E11882_01/appdev.112/e40758/d_resmgr.htm#ARPLS67611
http://docs.oracle.com/cd/E11882_01/server.112/e25494/dbrm.htm#ADMIN12659
关于属于联机事务处理(OLTP)组正在运行的会话,哪种说法是真实的?
D、如果会话超过10000 I/O请求或2500 MB的数据查询传输,但不用于数据操纵语言(DML)操作,它切换到低组的消费群体。
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/81227/viewspace-2124218/
,如需转载,请注明出处,否则将追究法律责任。