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._DBA_APPLY_READER_STATS

Object Details

Object Name:	_DBA_APPLY_READER_STATS
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length
APPLY#	NUMBER
SAVE_TIME	DATE
APPLY_NAME	VARCHAR2	(30)
STATE	NUMBER
STARTUP_TIME	DATE
MSG_NUM	NUMBER
TOTAL_MSG	NUMBER
TOTAL_SPILL_MSG	NUMBER
LAST_RCV_TIME	DATE
LAST_RCV_MSG_NUM	NUMBER
LAST_RCV_MSG_TIME	DATE
SGA_USED	NUMBER
ELAPSED_DEQUEUE_TIME	NUMBER
ELAPSED_SCHEDULE_TIME	NUMBER
ELAPSED_SPILL_TIME	NUMBER
LAST_BROWSE_NUM	NUMBER
OLDEST_SCN_NUM	NUMBER
LAST_BROWSE_SEQ	NUMBER
LAST_DEQ_SEQ	NUMBER
OLDEST_XID_USN	NUMBER
OLDEST_XID_SLT	NUMBER
OLDEST_XID_SQN	NUMBER
SPILL_LWM_SCN	NUMBER
COMMIT_POSITION	RAW	(64)
LAST_RCV_POS	RAW	(64)
LAST_BROWSE_POS	RAW	(64)
OLDEST_POS	RAW	(64)
SPILL_LWM_POS	RAW	(64)
FLAG	NUMBER
OLDEST_XIDTXT	VARCHAR2	(128)
NUM_DEPS	NUMBER
NUM_DEP_LCRS	NUMBER
NUM_WMDEPS	NUMBER
NUM_IN_MEMORY_LCRS	NUMBER
SGA_ALLOCATED	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#
,      SAVE_TIME
,      APPLY_NAME
,      STATE
,      STARTUP_TIME
,      MSG_NUM
,      TOTAL_MSG
,      TOTAL_SPILL_MSG
,      LAST_RCV_TIME
,      LAST_RCV_MSG_NUM
,      LAST_RCV_MSG_TIME
,      SGA_USED
,      ELAPSED_DEQUEUE_TIME
,      ELAPSED_SCHEDULE_TIME
,      ELAPSED_SPILL_TIME
,      LAST_BROWSE_NUM
,      OLDEST_SCN_NUM
,      LAST_BROWSE_SEQ
,      LAST_DEQ_SEQ
,      OLDEST_XID_USN
,      OLDEST_XID_SLT
,      OLDEST_XID_SQN
,      SPILL_LWM_SCN
,      COMMIT_POSITION
,      LAST_RCV_POS
,      LAST_BROWSE_POS
,      OLDEST_POS
,      SPILL_LWM_POS
,      FLAG
,      OLDEST_XIDTXT
,      NUM_DEPS
,      NUM_DEP_LCRS
,      NUM_WMDEPS
,      NUM_IN_MEMORY_LCRS
,      SGA_ALLOCATED
,      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._DBA_APPLY_READER_STATS;

Dependencies

[top of page]

SYS._DBA_APPLY_READER_STATS references the following:

SYS: APPLY$_READER_STATS

SYS._DBA_APPLY_READER_STATS is not referenced by any database object