9.90 V$SUBSCR_REGISTRATION_STATS
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:
|
Footnote 1 This column is available starting with Oracle Database release 19c, version 19.1.