Oracle 视图 V$GCR_METRICS 官方解释,作用,如何使用详细说明
本站中文解释
Oracle的V$GCR_METRICS是一种系统监视视图,它可以查询出Global Cache和Global Enqueue Services (GES)系统中的缓存数据。它用于监视系统性能,帮助有关的管理员采取适当措施改善性能。它可以用来检测以下事件:
1. 数据库中锁定的会话或资源
2. 多个实例之间无法保持一致性或完整性的全局数据
3. 在Global Cache Service中失效的心跳
4. 连接中出现的延迟
5. 在远程访问中出现的超时
为了使用这个视图,首先应该确定连接到数据库的实例的状态。如果实例已经关闭或发出SUSPEND或SUSPEND,那么应该不再使用V$GCR_METRICS视图。可以使用以下SQL查询来检查实例的状态:
SELECT * FROM V$INSTANCE;
接下来,就可以使用V$GCR_METRICS视图来确认系统中是否存在任何失效的会话或资源锁定,远程访问是否正常运行,全局缓存是否正常等。可以使用以下SQL语句来完成:
SELECT * FROM V$GCR_METRICS;
官方英文解释
V$GCR_METRICS
displays information about the current status of the metrics defined to the GCR component that runs under the LMHB background process to detect and mitigate potential issues in the cluster instances.
Column | Datatype | Description |
---|---|---|
|
|
Metric identification number as used internally to refer to the metric |
|
|
Name of the metric |
|
|
Environment that the metric should run in:
|
|
|
How often the metric runs, in seconds |
|
|
The scope of sharing of the metric:
|
|
|
The type of the data associated with this metric:
|
|
|
Indicates the status of the metric:
|
|
|
Time of last metric change of status |
|
|
Iteration of the last time the metric ran |
|
|
Time of last run |
|
|
Iteration of last time the metric passed |
|
|
Time of last metric pass |
|
|
Total number of times the metric passed since start of LMHB |
|
|
Iteration of last time the metric failed |
|
|
Time of last metric failure |
|
|
Total number of times the metric has failed since start of LMHB |
|
|
The ID of the container to which the data pertains. Possible values include:
|