Skip to content

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

VIEW: SYS._DBA_APPLY_COORDINATOR_STATS

Object Details
Object Name: _DBA_APPLY_COORDINATOR_STATS
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
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._DBA_APPLY_COORDINATOR_STATS;

Dependencies

[top of page]

SYS._DBA_APPLY_COORDINATOR_STATS references the following:

SchemaSYS
TableAPPLY$_COORDINATOR_STATS

SYS._DBA_APPLY_COORDINATOR_STATS is not referenced by any database object