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]

TABLE: SYS.APPLY$_COORDINATOR_STATS

Object Details

Object Name:	APPLY$_COORDINATOR_STATS
Object Type:	TABLE
Owner:	SYS
Subobject Name:
Status:	VALID

Storage Details

Tablespace:	SYSTEM
PCT Free:	10
PCT Used:	40

Indexes

Index	Type	Uniqueness	Tablespace	Column
APPLY$_COORDINATOR_STATS_I	NORMAL	NONUNIQUE	SYSTEM	APPLY# SAVE_TIME

Columns

Name	Datatype	Length
APPLY#	NUMBER
SAVE_TIME	DATE
APPLY_NAME	VARCHAR2	(30)
STATE	NUMBER
TOTAL_APPLIED	NUMBER
TOTAL_WAITDEPS	NUMBER
TOTAL_WAITCOMMITS	NUMBER
TOTAL_ADMIN	NUMBER
TOTAL_ASSIGNED	NUMBER
TOTAL_RECEIVED	NUMBER
TOTAL_IGNORED	NUMBER
TOTAL_ROLLBACKS	NUMBER
TOTAL_ERRORS	NUMBER
UNASSIGNED_EAGER	NUMBER
UNASSIGNED_COMPLETE	NUMBER
AUTO_TXNBUFSIZE	NUMBER
STARTUP_TIME	DATE
LWM_TIME	DATE
LWM_MSG_NUM	NUMBER
LWM_MSG_TIME	DATE
HWM_TIME	DATE
HWM_MSG_NUM	NUMBER
HWM_MSG_TIME	DATE
ELAPSED_SCHEDULE_TIME	NUMBER
ELAPSED_IDLE_TIME	NUMBER
LWM_POSITION	RAW	(64)
HWM_POSITION	RAW	(64)
PROCESSED_MSG_NUM	NUMBER
FLAG	NUMBER
FLAGS_FACTORING	NUMBER
REPLNAME	VARCHAR2	(30)
SPARE1	NUMBER
SPARE2	NUMBER
SPARE3	NUMBER
SPARE4	NUMBER
SPARE5	NUMBER
SPARE6	NUMBER
SPARE7	NUMBER
SPARE8	NUMBER
SPARE9	NUMBER
SPARE10	NUMBER
SPARE11	VARCHAR2	(4000)
SPARE12	VARCHAR2	(4000)
SPARE13	VARCHAR2	(4000)
SPARE14	VARCHAR2	(4000)
SPARE15	RAW	(1000)
SPARE16	RAW	(1000)
SPARE17	RAW	(1000)
SPARE18	DATE
SPARE19	DATE
SPARE20	DATE

Query Text

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


SELECT APPLY#
,      SAVE_TIME
,      APPLY_NAME
,      STATE
,      TOTAL_APPLIED
,      TOTAL_WAITDEPS
,      TOTAL_WAITCOMMITS
,      TOTAL_ADMIN
,      TOTAL_ASSIGNED
,      TOTAL_RECEIVED
,      TOTAL_IGNORED
,      TOTAL_ROLLBACKS
,      TOTAL_ERRORS
,      UNASSIGNED_EAGER
,      UNASSIGNED_COMPLETE
,      AUTO_TXNBUFSIZE
,      STARTUP_TIME
,      LWM_TIME
,      LWM_MSG_NUM
,      LWM_MSG_TIME
,      HWM_TIME
,      HWM_MSG_NUM
,      HWM_MSG_TIME
,      ELAPSED_SCHEDULE_TIME
,      ELAPSED_IDLE_TIME
,      LWM_POSITION
,      HWM_POSITION
,      PROCESSED_MSG_NUM
,      FLAG
,      FLAGS_FACTORING
,      REPLNAME
,      SPARE1
,      SPARE2
,      SPARE3
,      SPARE4
,      SPARE5
,      SPARE6
,      SPARE7
,      SPARE8
,      SPARE9
,      SPARE10
,      SPARE11
,      SPARE12
,      SPARE13
,      SPARE14
,      SPARE15
,      SPARE16
,      SPARE17
,      SPARE18
,      SPARE19
,      SPARE20
FROM SYS.APPLY$_COORDINATOR_STATS;

Dependencies

[top of page]

SYS.APPLY$_COORDINATOR_STATS does not reference any database object

SYS.APPLY$_COORDINATOR_STATS is referenced by following:

SYS: _DBA_APPLY_COORDINATOR_STATS