[Home] [Help] [Dependency Information]
Object Name: | V_$EMON |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
EMON# | NUMBER | |||
SID | NUMBER | |||
STARTUP_TIME | TIMESTAMP(3) WITH TIME ZONE | (20) | ||
SERVER_TYPE | VARCHAR2 | (8) | ||
STATUS | VARCHAR2 | (6) | ||
STATUS_CHANGE_TIME | TIMESTAMP(3) WITH TIME ZONE | (20) | ||
NUM_NTFNS | NUMBER | |||
NUM_GROUPING_NTFNS | NUMBER | |||
NUM_NTFNS_ALL_GROUPS | NUMBER | |||
NUM_OCI_NTFNS | NUMBER | |||
NUM_PLSQL_NTFNS | NUMBER | |||
NUM_EMAIL_NTFNS | NUMBER | |||
NUM_HTTP_NTFNS | NUMBER | |||
NUM_EVENTS_PROCESSED | NUMBER | |||
NUM_EVENTS_PENDING | NUMBER | |||
NUM_ANONYMOUS_NTFNS | NUMBER | |||
NUM_AQ_NTFNS | NUMBER | |||
NUM_DBCHANGE_NTFNS | NUMBER | |||
TOTAL_ANONYMOUS_NTFN_TIME | NUMBER | |||
TOTAL_AQ_NTFN_TIME | NUMBER | |||
TOTAL_DBCHANGE_NTFN_TIME | NUMBER | |||
TOTAL_PLSQL_NTFN_TIME | NUMBER | |||
TOTAL_OCI_NTFN_TIME | NUMBER | |||
TOTAL_EMAIL_NTFN_TIME | NUMBER | |||
TOTAL_HTTP_NTFN_TIME | NUMBER | |||
TOTAL_EMON_LATENCY | NUMBER | |||
REGISTRATIONS_EXPIRED | NUMBER | |||
REGISTRATIONS_PURGED | NUMBER | |||
REGISTRATIONS_INVALID | NUMBER | |||
LAST_UPDATE_TIME | TIMESTAMP(3) WITH TIME ZONE | (20) | ||
CON_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT EMON#
, SID
, STARTUP_TIME
, SERVER_TYPE
, STATUS
, STATUS_CHANGE_TIME
, NUM_NTFNS
, NUM_GROUPING_NTFNS
, NUM_NTFNS_ALL_GROUPS
, NUM_OCI_NTFNS
, NUM_PLSQL_NTFNS
, NUM_EMAIL_NTFNS
, NUM_HTTP_NTFNS
, NUM_EVENTS_PROCESSED
, NUM_EVENTS_PENDING
, NUM_ANONYMOUS_NTFNS
, NUM_AQ_NTFNS
, NUM_DBCHANGE_NTFNS
, TOTAL_ANONYMOUS_NTFN_TIME
, TOTAL_AQ_NTFN_TIME
, TOTAL_DBCHANGE_NTFN_TIME
, TOTAL_PLSQL_NTFN_TIME
, TOTAL_OCI_NTFN_TIME
, TOTAL_EMAIL_NTFN_TIME
, TOTAL_HTTP_NTFN_TIME
, TOTAL_EMON_LATENCY
, REGISTRATIONS_EXPIRED
, REGISTRATIONS_PURGED
, REGISTRATIONS_INVALID
, LAST_UPDATE_TIME
, CON_ID
FROM SYS.V_$EMON;
|
|
|