91 View the Exhibit and examine the resource consumption details for the current plan in use by the
来源:互联网 发布:淘宝代发怎么发货 编辑:程序博客网 时间:2024/06/10 22:54
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.)
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
Correct Answer: BC
Section: (none)
Explanation
Explanation/Reference:
Explanation:
http://download.oracle.com/docs/cd/B28359_01/server.111/b28310/dbrm009.htm
V$RSRC_CONSUMER_GROUP
Use the V$RSRC_CONSUMER_GROUP view to monitor CPU usage and CPU waits. It provides the
cumulative amount of CPU time consumed, cumulative amount of time waiting for CPU, and cumulative
number of CPU waits by all sessions in each consumer group. It also provides a number of other
measures helpful for tuning.
SQL> SELECT name, active_sessions, queue_length,
consumed_cpu_time, cpu_waits, cpu_wait_time
FROM v$rsrc_consumer_group;
- 91 View the Exhibit and examine the resource consumption details for the current plan in use by the
- 64.View the Exhibit and examine the data in the PROMO_CATEGORY and PROMO_COST columns of
- 85.View the Exhibit and examine the structure and data in the INVOICE table.
- 107.View the Exhibit and examine the structure and data in the INVOICE table.
- 161.View the exhibit and examine the description for the SALES and CHANNELS tables.
- 169.View the Exhibit and examine the description for the PRODUCTS and SALES table.
- 104.View the Exhibit to examine the details for an incident.
- 15.View the Exhibit and examine the data in the CUSTOMERS table.
- 17.View the Exhibit and examine the data in the EMPLOYEES table.
- 53.View the Exhibit and examine the data in the PROMOTIONS table.
- 59.View the Exhibit and examine the data in the PRODUCTS table.
- 66.View the Exhibit and examine the data in the COSTS table.
- 126.View the Exhibit and examine the data in the PROJ_TASK_DETAILS table.
- 130.View the Exhibit and examine the data in the EMPLOYEES table:
- 150.View the Exhibit and examine the data in the PROMOTIONS table.
- 40.View the Exhibit to examine the description for the SALES and PRODUCTS tables.
- 163.View the Exhibit and examine the description for the CUSTOMERS table.
- 165.View the Exhibit and examine the description for the CUSTOMERS table.
- [JavaScript]setTimeout传递对象参数
- 嵌入式操作系统学习笔记:02.环境搭建兼 Eclipse Jlink 2440 ARM裸机调试
- 毕设方向可能需要的书籍
- OC基础
- 论安卓适配器中的观察者模式
- 91 View the Exhibit and examine the resource consumption details for the current plan in use by the
- window下tomcat打印catalina.out问题
- 菜鸟学Java----继承
- 学习笔记栈
- ros用rqt_graph显示节点关系、rqt_plot显示数据流、rqt_console显示节点的输出、rqt_logger_level
- Nginx学习
- 排序 -- 思路简析(一)
- 啊违法
- 排序 -- 思路简析(二)