[Home] [Help] [Dependency Information]
Object Name: | V_$GG_APPLY_SERVER |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SID | NUMBER | |||
SERIAL# | NUMBER | |||
APPLY# | NUMBER | |||
APPLY_NAME | VARCHAR2 | (30) | ||
SERVER_ID | NUMBER | |||
STATE | VARCHAR2 | (20) | ||
XIDUSN | NUMBER | |||
XIDSLT | NUMBER | |||
XIDSQN | NUMBER | |||
COMMITSCN | NUMBER | |||
DEP_XIDUSN | NUMBER | |||
DEP_XIDSLT | NUMBER | |||
DEP_XIDSQN | NUMBER | |||
DEP_COMMITSCN | NUMBER | |||
MESSAGE_SEQUENCE | NUMBER | |||
TOTAL_ASSIGNED | NUMBER | |||
TOTAL_ADMIN | NUMBER | |||
TOTAL_ROLLBACKS | NUMBER | |||
TOTAL_MESSAGES_APPLIED | NUMBER | |||
APPLY_TIME | DATE | |||
ELAPSED_APPLY_TIME | NUMBER | |||
COMMIT_POSITION | VARCHAR2 | (64) | ||
DEP_COMMIT_POSITION | VARCHAR2 | (64) | ||
LAST_APPLY_POSITION | VARCHAR2 | (64) | ||
TRANSACTION_ID | VARCHAR2 | (128) | ||
DEP_TRANSACTION_ID | VARCHAR2 | (128) | ||
CON_ID | NUMBER | |||
TOTAL_LCRS_RETRIED | NUMBER | |||
LCR_RETRY_ITERATION | NUMBER | |||
TOTAL_TXNS_RETRIED | NUMBER | |||
TXN_RETRY_ITERATION | NUMBER | |||
TOTAL_TXNS_RECORDED | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT SID
, SERIAL#
, APPLY#
, APPLY_NAME
, SERVER_ID
, STATE
, XIDUSN
, XIDSLT
, XIDSQN
, COMMITSCN
, DEP_XIDUSN
, DEP_XIDSLT
, DEP_XIDSQN
, DEP_COMMITSCN
, MESSAGE_SEQUENCE
, TOTAL_ASSIGNED
, TOTAL_ADMIN
, TOTAL_ROLLBACKS
, TOTAL_MESSAGES_APPLIED
, APPLY_TIME
, ELAPSED_APPLY_TIME
, COMMIT_POSITION
, DEP_COMMIT_POSITION
, LAST_APPLY_POSITION
, TRANSACTION_ID
, DEP_TRANSACTION_ID
, CON_ID
, TOTAL_LCRS_RETRIED
, LCR_RETRY_ITERATION
, TOTAL_TXNS_RETRIED
, TXN_RETRY_ITERATION
, TOTAL_TXNS_RECORDED
FROM SYS.V_$GG_APPLY_SERVER;
|
|
|