[Home] [Help] [Dependency Information]
Object Name: | V_$XSTREAM_OUTBOUND_SERVER |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SID | NUMBER | |||
SERIAL# | NUMBER | |||
SPID | VARCHAR2 | (12) | ||
SERVER_NAME | VARCHAR2 | (30) | ||
STARTUP_TIME | DATE | |||
STATE | VARCHAR2 | (19) | ||
XIDUSN | NUMBER | |||
XIDSLT | NUMBER | |||
XIDSQN | NUMBER | |||
COMMITSCN | NUMBER | |||
TOTAL_TRANSACTIONS_SENT | NUMBER | |||
MESSAGE_SEQUENCE | NUMBER | |||
TOTAL_MESSAGES_SENT | NUMBER | |||
SEND_TIME | DATE | |||
LAST_SENT_MESSAGE_NUMBER | NUMBER | |||
LAST_SENT_MESSAGE_CREATE_TIME | DATE | |||
ELAPSED_SEND_TIME | NUMBER | |||
COMMIT_POSITION | RAW | (64) | ||
LAST_SENT_POSITION | RAW | (64) | ||
BYTES_SENT | NUMBER | |||
COMMITTED_DATA_ONLY | CHAR | (3) | ||
CON_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT SID
, SERIAL#
, SPID
, SERVER_NAME
, STARTUP_TIME
, STATE
, XIDUSN
, XIDSLT
, XIDSQN
, COMMITSCN
, TOTAL_TRANSACTIONS_SENT
, MESSAGE_SEQUENCE
, TOTAL_MESSAGES_SENT
, SEND_TIME
, LAST_SENT_MESSAGE_NUMBER
, LAST_SENT_MESSAGE_CREATE_TIME
, ELAPSED_SEND_TIME
, COMMIT_POSITION
, LAST_SENT_POSITION
, BYTES_SENT
, COMMITTED_DATA_ONLY
, CON_ID
FROM SYS.V_$XSTREAM_OUTBOUND_SERVER;
|
|
|