QUESTION NO: 521
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: B,C
查看圖表并檢查數(shù)據(jù)庫(kù)實(shí)例使用確當(dāng)前計(jì)劃的資源消費(fèi)明細(xì)。
基于輸出哪兩項(xiàng)描寫是真的?
B.屬于決策支持系統(tǒng)查詢的用戶可以登錄到1個(gè)新的會(huì)話,但會(huì)話將被排隊(duì)
C.CPU等待時(shí)間列表明由于資源管理在消費(fèi)組的會(huì)話等待CPU的總時(shí)間。