DBA Data[Home] [Help]

VIEW: SYS.GV_$EMON

Source

View Text - Preformatted

select "INST_ID","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","LAST_ERROR","LAST_ERROR_TIME","CON_ID" from gv$emon
View Text - HTML Formatted

SELECT "INST_ID"
, "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"
, "LAST_ERROR"
, "LAST_ERROR_TIME"
, "CON_ID"
FROM GV$EMON