Oracle 视图 DBA_HIST_RSRC_CONSUMER_GROUP 官方解释,作用,如何使用详细说明
Oracle视图DBA_HIST_RSRC_CONSUMER_GROUP用于报告Deferred Stats存储在AWR中与Oracle资源管理器关联的消耗者组总消耗情况。此视图显示在一段时间内(可以设定以秒为单位的时间间隔)Oracle资源管理器的消费情况,包括各个消费者组的时间和次数占比,消费者组活动等。
使用方法:
1. 创建一个显示信息的SQL语句,如:
SELECT SNAP_ID, CONSUMER_GROUP, ACTIVE_SESSIONS, DB_TIME_RATIO
FROM DBA_HIST_RSRC_CONSUMER_GROUP
WHERE BEGIN_INTERVAL_TIME SYSDATE 1
ORDER BY DB_TIME_RATIO DESC;
2. 运行上述SQL语句,来检查系统中的消费者组情况,如果发现某些消费者组的消费较多,可以进一步优化控制Oracle资源管理器的使用。
官方英文解释DBA_HIST_RSRC_CONSUMER_GROUP displays historical information about Resource Manager consumer groups.
This view contains snapshots of V$RSRC_CONS_GROUP_HISTORY.
A sequential counter that uniquely describes the DBA_HIST_RSRC_PLAN entry to which these consumer group statistics apply. When the instance is restarted, this value is reset to zero.
Consumer group object ID (a unique number, consistent across database shutdowns and startups)
Cumulative amount of time that sessions waited for CPU because of resource management. This does not include waits due to latch or enqueue contention, I/O waits, and so on.
Cumulative number of times all sessions in the consumer group had to wait for CPU because of resource management. This does not include waits due to latch or enqueue contention, I/O waits, and so on.
Cumulative amount of CPU time consumed by all sessions in the consumer group (in milliseconds)
Cumulative number of times that sessions in the consumer group had to yield CPU to other sessions because of quantum expiration
Number of times that sessions in the consumer group were queued because the consumer group reached its active session limit
Number of times that queries in the consumer group were cancelled because the consumer group reached its UNDO_POOL limit
Number of switches into the consumer group because of the Resource Manager plan s SWITCH_TIME limit
Number of switches out of the consumer group because of the Resource Manager plan s SWITCH_TIME limit
Number of switches into the consumer group because of the Resource Manager plan s SWITCH_IO_MEGABYTES limit
Number of switches out of the consumer group because of the Resource Manager plan s SWITCH_IO_MEGABYTES limit
Number of switches into the consumer group because of the Resource Manager plan s SWITCH_IO_REQS limit
Number of switches out of the consumer group because of the Resource Manager plan s SWITCH_IO_REQS limit
Number of switches into the consumer group because of the Resource Manager plan s SWITCH_IO_LOGICAL limit
Number of switches out of the consumer group because of the Resource Manager plan s SWITCH_IO_LOGICAL limit
Number of switches into the consumer group because of the Resource Manager plan s SWITCH_ELAPSED_TIME limit
Number of switches out of the consumer group because of the Resource Manager plan s SWITCH_ELAPSED_TIME limit
The number of sessions that were killed because their PGA allocation exceeded the PGA limit specified in the Resource Plan’s SESSION_PGA_LIMIT directive
Number of times that SQL queries running in the consumer group were aborted because they exceeded the Resource Manager plan s SWITCH_TIME limit and CANCEL_SQL was specified as the Resource Manager plan s SWITCH_GROUP
Number of times that sessions running in the consumer group were terminated because they exceeded the Resource Manager plan s SWITCH_TIME limit and KILL_SESSION was specified as the Resource Manager plan s SWITCH_GROUP
Number of times that sessions in the consumer group were killed because they were idle for too long (reached MAX_IDLE_TIME)
Number of times that sessions in the consumer group were killed because they were idle too long (reached MAX_IDLE_BLOCKER_TIME) and were blocking other sessions
Total amount of time that sessions in the consumer group have spent in the QUEUED state because of the active session limit (in milliseconds)
Number of times that requests from sessions in the consumer group timed out because they were queued for too long (reached QUEUEING_P1)
Number of times that sessions in the consumer group were queued when trying to run parallel statements
Total amount of time that sessions in the consumer group were queued when trying to run parallel statements (in milliseconds)
Number of times that parallel statements from sessions in the consumer group timed out because their queue time exceeded the Resource Manager plan s PARALLEL_QUEUE_TIMEOUT limit
Total number of parallel servers used by completed parallel statements in the consumer group
Cumulative sum of the parallel active times for all completed parallel statements in the consumer group (in milliseconds)
0: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs.
我想要获取技术服务或软件
服务范围:MySQL、ORACLE、SQLSERVER、MongoDB、PostgreSQL 、程序问题
服务方式:远程服务、电话支持、现场服务,沟通指定方式服务
技术标签:数据恢复、安装配置、数据迁移、集群容灾、异常处理、其它问题
本站部分文章参考或来源于网络,如有侵权请联系站长。
数据库远程运维 Oracle 视图 DBA_HIST_RSRC_CONSUMER_GROUP 官方解释,作用,如何使用详细说明
相关文章
- Oracle 视图 DBA_ACTIVITY_CONFIG 官方解释,作用,如何使用详细说明
- Oracle 视图 DBA_ATTRIBUTE_DIM_ORD_ATRS 官方解释,作用,如何使用详细说明
- Oracle 视图 DBA_CHECKED_ROLES 官方解释,作用,如何使用详细说明
- Oracle 视图 DBA_TSM_SOURCE 官方解释,作用,如何使用详细说明
- Oracle 视图 TAB 官方解释,作用,如何使用详细说明
- Oracle 视图 DBA_HISTOGRAMS 官方解释,作用,如何使用详细说明
- Oracle 视图 DBA_LOGSTDBY_EVENTS 官方解释,作用,如何使用详细说明
- Oracle 视图 DBA_ROLES 官方解释,作用,如何使用详细说明
- 如何使用 Oracle 导出表数据(oracle导出表命令)
- Oracle导出空表: 一步一步完成(oracle导空表)
- 删除Oracle中的字符(oracle删除字符)
- 记录Oracle数据库中字段类型更改(修改oracle字段类型)
- 灵活应用:Oracle 触发器类型介绍(oracle触发器类型)
- Oracle时间查询方法介绍(如何查看oracle时间)
- 突破极限:Oracle 语句优化实战(oracle语句优化)
- Oracle官方中文版下载—随时随地!(oracle中文官网下载)
- 排除Oracle 数据库故障排查:解决办法一览(oracle数据库故障)
- Oracle 时间点恢复 — 让数据一秒钟恢复!(oracle时间点恢复)
- 踩坑指南DOS操作Oracle数据库(dos操作oracle)
- Oracle事务 从终止到重启(oracle事务终止)
- Oracle位图索引管理有效实现数据高效访问(oracle 位图管理)
- Oracle中排序的优先级排序简介(oracle中排序的顺序)
- 统计Oracle两表联查分组统计性能优化实例分析(oracle两表联查分组)
- Oracle上个月同一天的数据分析(oracle上个月同一天)