V$SUBSCR_REGISTRATION_STATS displays information for diagnosability of notifications.
| Column | Datatype | Description |
|---|---|---|
REG_ID |
NUMBER |
Registration identifier |
NUM_NTFNS |
NUMBER |
Number of notifications |
NUM_GROUPING_NTFNS |
NUMBER |
Number of grouping notifications |
NUM_NTFNS_CURRENT_GROUP |
NUMBER |
Number of events received in the current group |
LAST_NTFN_START_TIME |
TIMESTAMP(3) WITH TIME ZONE |
Time when the last notification was started |
LAST_NTFN_SENT_TIME |
TIMESTAMP(3) WITH TIME ZONE |
Time when the last notification was sent |
TOTAL_EMON_LATENCY |
NUMBER |
Total EMON latency (time taken by the EMON slave to process notifications) |
EMON# |
NUMBER |
Active EMON slave serving the registration |
ALL_EMON_SERVERS |
RAW(2000) |
EMON slaves that served the registration |
TOTAL_PAYLOAD_BYTES_SENT |
NUMBER |
Total payload bytes sent |
NUM_RETRIES |
NUMBER |
Number of retries in sending notifications |
TOTAL_PLSQL_EXEC_TIME |
NUMBER |
Total PL/SQL callback execution time (relevant only for PL/SQL notifications) |
LAST_ERR |
VARCHAR2(90) |
Last error message |
LAST_ERR_TIME |
TIMESTAMP(3) WITH TIME ZONE |
Time of the last error |
LAST_UPDATE_TIME |
TIMESTAMP(3) WITH TIME ZONE |
Time of the last update |
NUM_PENDING_NTFNS |
NUMBER |
Number of notifications pending to be sent |
TOTAL_PENDING_NTFN_BYTESFoot 1 |
NUMBER |
Total number of bytes for notifications pending to be sent |
Footnote 1 This column is available starting with Oracle Database 11g Release 2 (11.2.0.2).