Oracle OCP 1Z0-053 Q20(Resource Manager&CPU_WAIT_TIME)
20.View the Exhibit and examine the resource consumption details for the current plan in use by the
database instance.
Which two statements are true based on the output? (Choose two.)
Exhibit:
A. An attempt to start a new session by the user belonging to DSS_QUERIES fails with an error
B. A user belonging to DSS_QUERIES can log in to a new session but the session will be queued
C. The CPU_WAIT_TIME column indicates the total time that sessions in the consumer group waited for
the CPU due to resource management
D. The CPU_WAIT_TIME column indicates the total time that sessions in the consumer group waited for
the CPU due to resource management, I/O waits, and latch or enqueue contention
Answer: BC
参考：http://blog.csdn.net/rlhua/article/details/13094993
CPU_WAIT_TIME不包含I/O waits, latch, enqueue等
database instance.
Which two statements are true based on the output? (Choose two.)
Exhibit:
A. An attempt to start a new session by the user belonging to DSS_QUERIES fails with an error
B. A user belonging to DSS_QUERIES can log in to a new session but the session will be queued
C. The CPU_WAIT_TIME column indicates the total time that sessions in the consumer group waited for
the CPU due to resource management
D. The CPU_WAIT_TIME column indicates the total time that sessions in the consumer group waited for
the CPU due to resource management, I/O waits, and latch or enqueue contention
Answer: BC
参考：http://blog.csdn.net/rlhua/article/details/13094993
CPU_WAIT_TIME不包含I/O waits, latch, enqueue等
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/8520577/viewspace-2062933/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
