eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: SYS.V_$EMON

Object Details

Object Name:	V_$EMON
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length
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

Query Text

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;

Dependencies

[top of page]

SYS.V_$EMON references the following:

SYS.V_$EMON is referenced by following:

PUBLIC: V$EMON