Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

E40402-08
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

V$SUBSCR_REGISTRATION_STATS

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).