[Home] [Help] [Dependency Information]
Object Name: | V_$SUBSCR_REGISTRATION_STATS |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
REG_ID | NUMBER | |||
NUM_NTFNS | NUMBER | |||
NUM_GROUPING_NTFNS | NUMBER | |||
NUM_NTFNS_CURRENT_GROUP | NUMBER | |||
LAST_NTFN_START_TIME | TIMESTAMP(3) WITH TIME ZONE | (20) | ||
LAST_NTFN_SENT_TIME | TIMESTAMP(3) WITH TIME ZONE | (20) | ||
TOTAL_EMON_LATENCY | NUMBER | |||
EMON# | NUMBER | |||
ALL_EMON_SERVERS | RAW | (2000) | ||
TOTAL_PAYLOAD_BYTES_SENT | NUMBER | |||
NUM_RETRIES | NUMBER | |||
TOTAL_PLSQL_EXEC_TIME | NUMBER | |||
LAST_ERR | VARCHAR2 | (90) | ||
LAST_ERR_TIME | TIMESTAMP(3) WITH TIME ZONE | (20) | ||
LAST_UPDATE_TIME | TIMESTAMP(3) WITH TIME ZONE | (20) | ||
NUM_PENDING_NTFNS | NUMBER | |||
TOTAL_PENDING_NTFN_BYTES | NUMBER | |||
CON_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT REG_ID
, NUM_NTFNS
, NUM_GROUPING_NTFNS
, NUM_NTFNS_CURRENT_GROUP
, LAST_NTFN_START_TIME
, LAST_NTFN_SENT_TIME
, TOTAL_EMON_LATENCY
, EMON#
, ALL_EMON_SERVERS
, TOTAL_PAYLOAD_BYTES_SENT
, NUM_RETRIES
, TOTAL_PLSQL_EXEC_TIME
, LAST_ERR
, LAST_ERR_TIME
, LAST_UPDATE_TIME
, NUM_PENDING_NTFNS
, TOTAL_PENDING_NTFN_BYTES
, CON_ID
FROM SYS.V_$SUBSCR_REGISTRATION_STATS;
|
|
|