Oracle 视图 V$SUBSCR_REGISTRATION_STATS 官方解释，作用，如何使用详细说明
本站中文解释
Oracle 视图V$SUBSCR_REGISTRATION_STATS统计表达式订阅进程的当前注册状态，用于分析表达式订阅过程的状态及对比当前的各个状态的不同时段的注册情况。V$SUBSCR_REGISTRATION_STATS包含如下字段：
•AQ_NAME：采用表达式订阅的队列名
•SUBSCRIBER_NAME：订阅者名称
•CREATION_TIME：订阅过程注册时刻，以本地时间显示
•LAST_FAILURE_TIME：最后一次订阅失败的时刻，以本地时间显示
•SUCCESS_COUNT：成功订阅的次数
•FAILURE_COUNT：失败的订阅次数
•ITERATION_COUNT：表达式订阅迭代次数
•ITERATION_BEGIN_TIME：上一次迭代开始时间，以本地时间显示
•ITERATION_END_TIME：上一次迭代结束时间，以本地时间显示
•STATUS：当前订阅状态，有可能是SUCCEEDED、FAILED、RETRYING、RUNNING或其他状态
使用方法：
1.运行sql语句查看订阅者当前的状态：
SELECT status,subscriber_name
FROM V$SUBSCR_REGISTRATION_STATS;
2.查看特定订阅者最近5次订阅成功次数：
SELECT SUBSCRIBER_NAME,SUCCESS_COUNT
FROM V$SUBSCR_REGISTRATION_STATS
WHERE SUBSCRIBER_NAME = ‘subs_name’
ORDER BY SUCCESS_COUNT DESC
FETCH FIRST 5 ROWS ONLY;
3.检查应用程序在10分钟内是否注册成功：
SELECT SUBSCRIBER_NAME，SUCCESS_COUNT
FROM V$SUBSCR_REGISTRATION_STATS
WHERE CREATION_TIME > SYSDATE – 10/ 1440;
官方英文解释
V$SUBSCR_REGISTRATION_STATS displays information for diagnosability of notifications.
| Column | Datatype | Description |
|---|---|---|
|
|
|
Registration identifier |
|
|
|
Number of notifications |
|
|
|
Number of grouping notifications |
|
|
|
Number of events received in the current group |
|
|
|
Time when the last notification was started |
|
|
|
Time when the last notification was sent |
|
|
|
Total EMON latency (time taken by the EMON slave to process notifications) |
|
|
|
Active EMON slave serving the registration |
|
|
|
EMON slaves that served the registration |
|
|
|
Total payload bytes sent |
|
|
|
Shard number for current registration used for Key Based Messaging |
|
|
|
Number of retries in sending notifications |
|
|
|
Total PL/SQL callback execution time (relevant only for PL/SQL notifications) |
|
|
|
Last error message |
|
|
|
Time of the last error |
|
|
|
Time of the last update |
|
|
|
Number of notifications pending to be sent |
|
|
|
Total number of bytes for notifications pending to be sent |
|
|
|
The ID of the container to which the data pertains. Possible values include:
|
