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部落格 ” ,連結:http://blog.itpub.net/8520577/viewspace-2062933/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Oracle OCP(56)Oracle
- Oracle OCP(23):序列Oracle
- Oracle OCP(29):PROFILEOracle
- Oracle OCP(54):EXPOracle
- Oracle OCP(54):IMPOracle
- Oracle OCP(57):IMPDPOracle
- Oracle OCP(44):LSNRCTLOracle
- Oracle OCP(28):USEROracle
- Oracle OCP(25):索引Oracle索引
- Oracle OCP(30):ROLEOracle
- Oracle OCP(33):官方文件Oracle
- Oracle OCP(20):建立表Oracle
- Oracle OCP(21):管理表Oracle
- Oracle OCP(12):ROLLUP & CUBEOracle
- Oracle OCP(48):UNDO TABLESPACEOracle
- Oracle OCP(58):ARCHIVELOG 管理OracleHive
- Oracle OCP(24):檢視Oracle
- Oracle OCP(26):其它ObjectOracleObject
- Oracle OCP(32):SUPPORT:MOSOracle
- 2.7 Overview of Oracle Resource Manager in a CDBViewOracle
- Oracle OCP(35):Database 安裝OracleDatabase
- Oracle OCP(36):DBCA建庫Oracle
- Oracle OCP(04):聚合函式Oracle函式
- Oracle OCP(43):listener.oraOracle
- Oracle OCP(40):程式結構Oracle
- Oracle OCP(18):命名規則Oracle
- Oracle OCP(60):RMAN 備份Oracle
- Oracle OCP(45):sqlnet.oraOracleSQL
- Oracle OCP(45):TNSNAMES.oraOracle
- Oracle OCP(62):熱備份Oracle
- Oracle OCP(60):冷備份Oracle
- Oracle OCP和MySQL OCP認證考試內容有哪些?OracleMySql
- Oracle OCP(02):條件和排序Oracle排序
- Oracle OCP(41):邏輯結構Oracle
- Oracle OCP(38):Database 物理結構OracleDatabase
- Oracle OCP(15):分層檢索Oracle
- Oracle OCP(19):資料型別Oracle資料型別
- Oracle OCP(08):使用子查詢Oracle
- Oracle OCP(09):使用集合運算子Oracle