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$_SERVER_STATS

Object Details

Object Name:	APPLY$_SERVER_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$_SERVER_STATS_I	NORMAL	NONUNIQUE	SYSTEM	APPLY# SERVER_ID SAVE_TIME

Columns

Name	Datatype	Length
APPLY#	NUMBER
SERVER_ID	NUMBER
SAVE_TIME	DATE
APPLY_NAME	VARCHAR2	(30)
STATE	NUMBER
STARTUP_TIME	DATE
XID_USN	NUMBER
XID_SLT	NUMBER
XID_SQN	NUMBER
CSCN	NUMBER
DEPXID_USN	NUMBER
DEPXID_SLT	NUMBER
DEPXID_SQN	NUMBER
DEPCSCN	NUMBER
MSG_NUM	NUMBER
TOTAL_ASSIGNED	NUMBER
TOTAL_ADMIN	NUMBER
TOTAL_ROLLBACKS	NUMBER
TOTAL_MSG	NUMBER
LAST_APPLY_TIME	DATE
LAST_APPLY_MSG_NUM	NUMBER
LAST_APPLY_MSG_TIME	DATE
ELAPSED_APPLY_TIME	NUMBER
COMMIT_POSITION	RAW	(64)
DEP_COMMIT_POSITION	RAW	(64)
LAST_APPLY_POS	RAW	(64)
FLAG	NUMBER
NOSXID	VARCHAR2	(128)
DEPNOSXID	VARCHAR2	(128)
MAX_INST_SCN	NUMBER
TOTAL_WAITDEPS	NUMBER
TOTAL_LCRS_RETRIED	NUMBER
TOTAL_TXNS_RETRIED	NUMBER
TXN_RETRY_ITER	NUMBER
LCR_RETRY_ITER	NUMBER
TOTAL_TXNS_DISCARDED	NUMBER
FLAGS_FACTORING	NUMBER
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#
,      SERVER_ID
,      SAVE_TIME
,      APPLY_NAME
,      STATE
,      STARTUP_TIME
,      XID_USN
,      XID_SLT
,      XID_SQN
,      CSCN
,      DEPXID_USN
,      DEPXID_SLT
,      DEPXID_SQN
,      DEPCSCN
,      MSG_NUM
,      TOTAL_ASSIGNED
,      TOTAL_ADMIN
,      TOTAL_ROLLBACKS
,      TOTAL_MSG
,      LAST_APPLY_TIME
,      LAST_APPLY_MSG_NUM
,      LAST_APPLY_MSG_TIME
,      ELAPSED_APPLY_TIME
,      COMMIT_POSITION
,      DEP_COMMIT_POSITION
,      LAST_APPLY_POS
,      FLAG
,      NOSXID
,      DEPNOSXID
,      MAX_INST_SCN
,      TOTAL_WAITDEPS
,      TOTAL_LCRS_RETRIED
,      TOTAL_TXNS_RETRIED
,      TXN_RETRY_ITER
,      LCR_RETRY_ITER
,      TOTAL_TXNS_DISCARDED
,      FLAGS_FACTORING
,      SPARE1
,      SPARE2
,      SPARE3
,      SPARE4
,      SPARE5
,      SPARE6
,      SPARE7
,      SPARE8
,      SPARE9
,      SPARE10
,      SPARE11
,      SPARE12
,      SPARE13
,      SPARE14
,      SPARE15
,      SPARE16
,      SPARE17
,      SPARE18
,      SPARE19
,      SPARE20
FROM SYS.APPLY$_SERVER_STATS;

Dependencies

[top of page]

SYS.APPLY$_SERVER_STATS does not reference any database object

SYS.APPLY$_SERVER_STATS is referenced by following:

SYS: _DBA_APPLY_SERVER_STATS