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_$QMON_COORDINATOR_STATS

Object Details

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

[View Source]

Columns

Name	Datatype	Length
QMNC_PID	VARCHAR2	(24)
STATUS	VARCHAR2	(24)
NUM_SERVERS	NUMBER
LAST_SERVER_START_TIME	TIMESTAMP(3) WITH TIME ZONE	(20)
LAST_SERVER_PID	VARCHAR2	(24)
NEXT_WAKEUP_TIME	TIMESTAMP(3) WITH TIME ZONE	(20)
NEXT_READY_TIME	TIMESTAMP(3) WITH TIME ZONE	(20)
NEXT_EXPIRY_TIME	TIMESTAMP(3) WITH TIME ZONE	(20)
LAST_WAIT_TIME	TIMESTAMP(3) WITH TIME ZONE	(20)
LAST_FAILURE	VARCHAR2	(32)
LAST_FAILURE_TIME	TIMESTAMP(3) WITH TIME ZONE	(20)
MAX_TASK_LATENCY	VARCHAR2	(40)
MIN_TASK_LATENCY	VARCHAR2	(40)
TOTAL_TASK_LATENCY	NUMBER
TOTAL_TASKS_EXECUTED	NUMBER
MAX_SERVERS	NUMBER
CON_ID	NUMBER

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT QMNC_PID
,      STATUS
,      NUM_SERVERS
,      LAST_SERVER_START_TIME
,      LAST_SERVER_PID
,      NEXT_WAKEUP_TIME
,      NEXT_READY_TIME
,      NEXT_EXPIRY_TIME
,      LAST_WAIT_TIME
,      LAST_FAILURE
,      LAST_FAILURE_TIME
,      MAX_TASK_LATENCY
,      MIN_TASK_LATENCY
,      TOTAL_TASK_LATENCY
,      TOTAL_TASKS_EXECUTED
,      MAX_SERVERS
,      CON_ID
FROM SYS.V_$QMON_COORDINATOR_STATS;

Dependencies

[top of page]

SYS.V_$QMON_COORDINATOR_STATS references the following:

SYS.V_$QMON_COORDINATOR_STATS is referenced by following:

PUBLIC: V$QMON_COORDINATOR_STATS