13 XStream Static Data Dictionary Views

This chapter describes the static data dictionary views related to XStream.

This chapter contains these topics:

ALL_APPLY
ALL_APPLY_ERROR
ALL_XSTREAM_INBOUND
ALL_XSTREAM_INBOUND_PROGRESS
ALL_XSTREAM_OUTBOUND
ALL_XSTREAM_OUTBOUND_PROGRESS
ALL_XSTREAM_RULES
DBA_APPLY
DBA_APPLY_ERROR
DBA_APPLY_SPILL_TXN
DBA_XSTREAM_INBOUND
DBA_XSTREAM_INBOUND_PROGRESS
DBA_XSTREAM_OUTBOUND
DBA_XSTREAM_OUTBOUND_PROGRESS
DBA_XSTREAM_RULES

See Also:

ALL_APPLY

ALL_APPLY displays information about the apply processes that dequeue events from queues accessible to the current user.

Related View

DBA_APPLY displays information about all apply processes in the database.

Column	Data Type	NULL	Description
`APPLY_NAME`	`VARCHAR2(30)`	`NOT NULL`	Name of the apply process
`QUEUE_NAME`	`VARCHAR2(30)`	`NOT NULL`	Name of the queue from which the apply process dequeues
`QUEUE_OWNER`	`VARCHAR2(30)`	`NOT NULL`	Owner of the queue from which the apply process dequeues
`APPLY_CAPTURED`	`VARCHAR2(3)`		Indicates whether the apply process applies captured events (`YES`) or user-enqueued events (`NO`)
`RULE_SET_NAME`	`VARCHAR2(30)`		Name of the positive rule set used by the apply process for filtering
`RULE_SET_OWNER`	`VARCHAR2(30)`		Owner of the positive rule set used by the apply process for filtering
`APPLY_USER`	`VARCHAR2(30)`		User who is applying events
`APPLY_DATABASE_LINK`	`VARCHAR2(128)`		Database link to which changes are applied. If null, then changes are applied to the local database.
`APPLY_TAG`	`RAW(2000)`		Tag associated with redo log records that are generated when changes are made by the apply process
`DDL_HANDLER`	`VARCHAR2(98)`		Name of the user-specified DDL handler, which handles DDL logical change records
`PRECOMMIT_HANDLER`	`VARCHAR2(98)`		Name of the user-specified pre-commit handler
`MESSAGE_HANDLER`	`VARCHAR2(98)`		Name of the user-specified procedure that handles dequeued events other than logical change records
`STATUS`	`VARCHAR2(8)`		Status of the apply process: `DISABLED` `ENABLED` `ABORTED`
`MAX_APPLIED_MESSAGE_NUMBER`	`NUMBER`		System change number (SCN) corresponding to the apply process high-watermark for the last time the apply process was stopped using the `DBMS_APPLY_ADM.STOP_APPLY` procedure with the `force` parameter set to `false`. The apply process high-watermark is the SCN beyond which no events have been applied.
`NEGATIVE_RULE_SET_NAME`	`VARCHAR2(30)`		Name of the negative rule set used by the apply process for filtering
`NEGATIVE_RULE_SET_OWNER`	`VARCHAR2(30)`		Owner of the negative rule set used by the apply process for filtering
`STATUS_CHANGE_TIME`	`DATE`		Time that the `STATUS` of the apply process was changed
`ERROR_NUMBER`	`NUMBER`		Error number if the apply process was aborted
`ERROR_MESSAGE`	`VARCHAR2(4000)`		Error message if the apply process was aborted
`MESSAGE_DELIVERY_MODE`	`VARCHAR2(10)`		Reserved for internal use
`PURPOSE`	`VARCHAR2(19)`		Purpose of the apply process: `STREAMS` `APPLY` for an apply process `XSTREAM` `OUT` for an XStream outbound server `XSTREAM` `IN` for an XStream inbound server

See Also:

"DBA_APPLY"

ALL_APPLY_ERROR

ALL_APPLY_ERROR displays information about the error transactions generated by the apply processes that dequeue events from queues accessible to the current user.

Related View

DBA_APPLY_ERROR displays information about the error transactions generated by all apply processes in the database.

Column	Data Type	Description
`APPLY_NAME`	`VARCHAR2(30)`	Name of the apply process at the local database which processed the transaction
`QUEUE_NAME`	`VARCHAR2(30)`	Name of the queue at the local database from which the transaction was dequeued
`QUEUE_OWNER`	`VARCHAR2(30)`	Owner of the queue at the local database from which the transaction was dequeued
`LOCAL_TRANSACTION_ID`	`VARCHAR2(22)`	Local transaction ID for the error transaction
`SOURCE_DATABASE`	`VARCHAR2(128)`	Database where the transaction originated
`SOURCE_TRANSACTION_ID`	`VARCHAR2(128)`	Original transaction ID at the source database
`SOURCE_COMMIT_SCN`	`NUMBER`	Original commit system change number (SCN) for the transaction at the source database
`MESSAGE_NUMBER`	`NUMBER`	Identifier for the event in the transaction that raised an error
`ERROR_NUMBER`	`NUMBER`	Error number of the error raised by the transaction
`ERROR_MESSAGE`	`VARCHAR2(4000)`	Error message of the error raised by the transaction
`RECIPIENT_ID`	`NUMBER`	User ID of the original user that applied the transaction
`RECIPIENT_NAME`	`VARCHAR2(30)`	Name of the original user that applied the transaction
`MESSAGE_COUNT`	`NUMBER`	Total number of events inside the error transaction
`ERROR_CREATION_TIME`	`DATE`	Time that the error was created
`SOURCE_COMMIT_POSITION`	`RAW(64)`	Original commit position for the transaction

See Also:

"DBA_APPLY_ERROR"

ALL_XSTREAM_INBOUND

ALL_XSTREAM_INBOUND displays information about the XStream inbound servers accessible to the current user.

Related View

DBA_XSTREAM_INBOUND displays information about all XStream inbound servers in the database.

Column	Data Type	NULL	Description
`SERVER_NAME`	`VARCHAR2(30)`	`NOT NULL`	Name of the inbound server
`QUEUE_OWNER`	`VARCHAR2(30)`	`NOT NULL`	Owner of the queue associated with the inbound server
`QUEUE_NAME`	`VARCHAR2(30)`	`NOT NULL`	Name of the queue associated with the inbound server
`APPLY_USER`	`VARCHAR2(30)`		Name of the user who is applying the messages
`USER_COMMENT`	`VARCHAR2(4000)`		User comment
`CREATE_DATE`	`TIMESTAMP(6)`		Date when the inbound server was created

See Also:

"DBA_XSTREAM_INBOUND"

ALL_XSTREAM_INBOUND_PROGRESS

ALL_XSTREAM_INBOUND_PROGRESS displays information about the progress made by the XStream inbound servers accessible to the current user.

Related View

DBA_XSTREAM_INBOUND_PROGRESS displays information about the progress made by all XStream inbound servers in the database.

Column	Data Type	NULL	Description
`SERVER_NAME`	`VARCHAR2(30)`	`NOT NULL`	Name of the inbound server
`PROCESSED_LOW_POSITION`	`RAW(64)`		Position of the processed low transaction
`APPLIED_LOW_POSITION`	`RAW(64)`		All messages with a commit position less than this value have been applied
`APPLIED_HIGH_POSITION`	`RAW(64)`		Highest commit position of a transaction that has been applied
`SPILL_POSITION`	`RAW(64)`		Position of the spill low-watermark

See Also:

"DBA_XSTREAM_INBOUND_PROGRESS"

ALL_XSTREAM_OUTBOUND

ALL_XSTREAM_OUTBOUND displays information about the XStream outbound servers accessible to the current user.

Related View

DBA_XSTREAM_OUTBOUND displays information about all XStream outbound servers in the database.

Column	Data Type	NULL	Description
`SERVER_NAME`	`VARCHAR2(30)`	`NOT NULL`	Name of the outbound server
`CONNECT_USER`	`VARCHAR2(30)`		Name of the user who can process the outbound LCRs
`CAPTURE_NAME`	`VARCHAR2(30)`		Name of the Streams capture process
`SOURCE_DATABASE`	`VARCHAR2(128)`		Database where the transaction originated
`CAPTURE_USER`	`VARCHAR2(30)`		Current user who is enqueuing captured messages
`QUEUE_OWNER`	`VARCHAR2(30)`	`NOT NULL`	Owner of the queue associated with the outbound server
`QUEUE_NAME`	`VARCHAR2(30)`	`NOT NULL`	Name of the queue associated with the outbound server
`USER_COMMENT`	`VARCHAR2(4000)`		User comment
`CREATE_DATE`	`TIMESTAMP(6)`		Date when the outbound server was created

See Also:

"DBA_XSTREAM_OUTBOUND"

ALL_XSTREAM_OUTBOUND_PROGRESS

ALL_XSTREAM_OUTBOUND_PROGRESS displays information about the progress made by the XStream outbound servers accessible to the current user.

Related View

DBA_XSTREAM_OUTBOUND_PROGRESS displays information about the progress made by all XStream outbound servers in the database.

Column	Data Type	NULL	Description
`SERVER_NAME`	`VARCHAR2(30)`	`NOT NULL`	Name of the outbound server
`SOURCE_DATABASE`	`VARCHAR2(128)`		Database where the transaction originated
`PROCESSED_LOW_POSITION`	`RAW(64)`		Position of the low-watermark transaction processed by the client
`PROCESSED_LOW_TIME`	`DATE`		Time when the processed low position was last updated by the outbound server

See Also:

"DBA_XSTREAM_OUTBOUND_PROGRESS"

ALL_XSTREAM_RULES

ALL_XSTREAM_RULES displays information about the XStream server rules accessible to the current user.

Related View

DBA_XSTREAM_RULES displays information about all XStream server rules in the database.

Column	Data Type	NULL	Description
`STREAMS_NAME`	`VARCHAR2(30)`		Name of the Streams process
`STREAMS_TYPE`	`VARCHAR2(12)`		Type of the Streams process: `CAPTURE` `APPLY`
`STREAMS_RULE_TYPE`	`VARCHAR2(6)`		For global, schema, or table rules, the type of the rule: `TABLE` `SCHEMA` `GLOBAL`
`RULE_SET_OWNER`	`VARCHAR2(30)`		Owner of the rule set
`RULE_SET_NAME`	`VARCHAR2(30)`		Name of the rule set
`RULE_SET_TYPE`	`CHAR(8)`		Type of the rule set: `POSITIVE` `NEGATIVE`
`RULE_OWNER`	`VARCHAR2(30)`	`NOT NULL`	Owner of the rule
`RULE_NAME`	`VARCHAR2(30)`	`NOT NULL`	Name of the rule
`RULE_TYPE`	`VARCHAR2(3)`		For global, schema, or table rules, the type of the rule: `DML` `DDL`
`RULE_CONDITION`	`CLOB`		Current rule condition
`SCHEMA_NAME`	`VARCHAR2(30)`		For table and schema rules, the schema name
`OBJECT_NAME`	`VARCHAR2(30)`		For table rules, the table name
`INCLUDE_TAGGED_LCR`	`VARCHAR2(3)`		For global, schema, or table rules, indicates whether to include tagged logical change records (LCRs) (`YES`) or not (`NO`)
`SUBSETTING_OPERATION`	`VARCHAR2(6)`		For subset rules, the type of operation: `INSERT` `UPDATE` `DELETE`
`DML_CONDITION`	`VARCHAR2(4000)`		For subset rules, the row subsetting condition
`SOURCE_DATABASE`	`VARCHAR2(128)`		For global, schema, or table rules, the name of the database where the LCRs originated
`ORIGINAL_RULE_CONDITION`	`VARCHAR2(4000)`		For rules created by Streams administrative APIs, the original rule condition when the rule was created
`SAME_RULE_CONDITION`	`VARCHAR2(3)`		For rules created by Streams administrative APIs, indicates whether the current rule condition is the same as the original rule condition (`YES`) or not (`NO`)

See Also:

"DBA_XSTREAM_RULES"

DBA_APPLY

DBA_APPLY displays information about all apply processes in the database. Its columns are the same as those in ALL_APPLY.

See Also:

"ALL_APPLY"

DBA_APPLY_ERROR

DBA_APPLY_ERROR displays information about the error transactions generated by all apply processes in the database. Its columns are the same as those in ALL_APPLY_ERROR.

See Also:

"ALL_APPLY_ERROR"

DBA_APPLY_SPILL_TXN

DBA_APPLY_SPILL_TXN displays information about the transactions spilled from memory to hard disk by all apply processes in the database.

Column	Data Type	NULL	Description
`APPLY_NAME`	`VARCHAR2(30)`	`NOT NULL`	Name of the apply process that spilled one or more transactions
`XIDUSN`	`NUMBER`	`NOT NULL`	Transaction ID undo segment number
`XIDSLT`	`NUMBER`	`NOT NULL`	Transaction ID slot number
`XIDSQN`	`NUMBER`	`NOT NULL`	Transaction ID sequence number
`FIRST_SCN`	`NUMBER`	`NOT NULL`	SCN of the first message in the transaction
`MESSAGE_COUNT`	`NUMBER`		Number of messages spilled for the transaction
`FIRST_MESSAGE_CREATE_TIME`	`DATE`		Source creation time of the first message in the transaction
`SPILL_CREATION_TIME`	`DATE`		Time the first message was spilled
`FIRST_POSITION`	`RAW(64)`		Position of the first message in this transaction
`TRANSACTION_ID`	`VARCHAR2(128)`		Transaction ID of the spilled transaction

DBA_XSTREAM_INBOUND

DBA_XSTREAM_INBOUND displays information about all XStream inbound servers in the database. Its columns are the same as those in ALL_XSTREAM_INBOUND.

See Also:

"ALL_XSTREAM_INBOUND"

DBA_XSTREAM_INBOUND_PROGRESS

DBA_XSTREAM_INBOUND_PROGRESS displays information about the progress made by all XStream inbound servers in the database. Its columns are the same as those in ALL_XSTREAM_INBOUND_PROGRESS.

See Also:

"ALL_XSTREAM_INBOUND_PROGRESS"

DBA_XSTREAM_OUTBOUND

DBA_XSTREAM_OUTBOUND displays information about all XStream outbound servers in the database. Its columns are the same as those in ALL_XSTREAM_OUTBOUND.

See Also:

"ALL_XSTREAM_OUTBOUND"

DBA_XSTREAM_OUTBOUND_PROGRESS

DBA_XSTREAM_OUTBOUND_PROGRESS displays information about the progress made by all XStream outbound servers in the database. Its columns are the same as those in ALL_XSTREAM_OUTBOUND_PROGRESS.

See Also:

"ALL_XSTREAM_OUTBOUND_PROGRESS"

DBA_XSTREAM_RULES

DBA_XSTREAM_RULES displays information about all XStream server rules in the database. Its columns are the same as those in ALL_XSTREAM_RULES.

See Also:

"ALL_XSTREAM_RULES"