Results for LCRs


41 to 100 of 507 results. Prev  Next
Results per page:  20 | 40 |  60 


Streams Concepts and Administration, 11g Release 2 (11.2)

Monitoring Oracle Streams Queues and Propagations

Viewing the Capture Processes for the LCRs in Each Buffered QueueLCRs can be propagated to other queues subsequently. By querying the V$BUFFERED_PUBLISHERS dynamic … performance view, you can display each capture process that captured the LCRs in the buffered queue … . These LCRs might have been captured at the local database, or they might have been captured at a … that the buffered queues

Streams Concepts and Administration, 11g Release 2 (11.2)

Monitoring Oracle Streams Apply Processes

Step 4   Create a Procedure that Prints All the LCRs in the Error QueueThe following procedure prints all of the LCRs in all of the error queues. It calls the print_lcr

Streams Extended Examples, 11g Release 2 (11.2)

Single-Source Heterogeneous Replication Example

Step 11   Create the Custom Rule-Based Transformation for Row LCRs at dbs2.example.combe required for the DDL LCRs. This transformation would need to change the object name and the DDL

Streams Extended Examples, 11g Release 2 (11.2)

Single-Source Heterogeneous Replication Example

Step 11   Create the Custom Rule-Based Transformation for Row LCRs at dbs2.example.combe required for the DDL LCRs. This transformation would need to change the object name and the DDL

Database XStream Guide, 11g Release 2 (11.2)

XStream Concepts

ID Key LCRsand the outbound server are enabled, data changes, encapsulated in row LCRs and DDL LCRs, are sent to … the outbound server. The outbound server can publish LCRs in various formats, such as OCI and Java … . The client application can process LCRs that are passed to it from the outbound server or wait for … LCRs

Database XStream Guide, 11g Release 2 (11.2)

XStream Concepts

Position of LCRs and XStream OutAn XStream Out outbound server streams LCRs that were captured by a capture process to a client … . Additional LCR Attributes Related to Position LCRs that were captured by a capture process contain the … present in row LCRs captured by a synchronous capture nor in explicitly captured row LCRs. See Also … processed

Database XStream Guide, 11g Release 2 (11.2)

XStream Concepts

Position of LCRs and XStream InA client application streams LCRs to an XStream In inbound server. This section describes concepts … positions are important for inbound servers: The applied low position indicates that the LCRs less than … indicates that the LCRs with positions less than or equal to this value have either been applied or … longer requires any

Database XStream Guide, 11g Release 2 (11.2)

Troubleshooting XStream

LCRs Streaming from an Outbound Server Are Missing Extra AttributesLCRs streaming from an outbound server are expected to include extra attributes, but these … attributes are not included in the LCRs. LCRs can contain the following extra attributes related to database … capture these extra attributes. If you want extra attributes to be included in LCRs streamed from an … outbound

Database PL/SQL Packages and Types Reference, 11g Release 2 (11.2)

DBMS_STREAMS_ADM

SET_MESSAGE_TRACKING ProcedureSets the tracking label for logical change records (LCRs) produced by the current session. This … procedure affects only the current session. Any LCRs produced by the current session are tracked … , including captured LCRs and persistent LCRs. Note: The tracking label set by this procedure does not … Description

Database PL/SQL Packages and Types Reference, 11g Release 2 (11.2)

Logical Change Record TYPEs

OverviewIn Oracle Streams, logical change records (LCRs) are message payloads that contain information … ) changes. When you use Oracle Streams, the capture process captures changes in the form of LCRs and … enqueues them into a queue. These LCRs can be propagated from a queue in one database to a queue in … another database. Finally,

Database PL/SQL Packages and Types Reference, 11g Release 2 (11.2)

DBMS_STREAMS

CONVERT_XML_TO_LCR Function(LCRs) into an LCR encapsulated in a ANYDATA object. The LCR can be a row or DDL LCR. See Also: Oracle … Streams Concepts and Administration for more information about the XML schema for LCRs Syntax … object does not conform to XML schema for LCRs, then the function raises an exception.

Database PL/SQL Packages and Types Reference, 11g Release 2 (11.2)

DBMS_APPLY_ADM

SET_TABLE_INSTANTIATION_SCN Procedure… This procedure gives you precise control over which logical change records (LCRs) for a table are … ignored and which LCRs are applied by an apply component. Syntax … and LCRs The SET_TABLE_INSTANTIATION_SCN Procedure and XStream Outbound Servers The … SET_TABLE_INSTANTIATION_SCN Procedure and XStream Inbound Servers

Database Reference, 11g Release 2 (11.2)

V$STREAMS_TRANSACTION

V$STREAMS_TRANSACTIONchange records (LCRs) are being processed in each transaction. This view only contains information … about captured LCRs. It does not contain information about user-enqueued LCRs or user messages. This … view only shows information about LCRs that are being processed because they satisfied the rule … information

Streams Concepts and Administration, 11g Release 2 (11.2)

How Oracle Streams Works with Other Database Components

Explicit Capture and Transparent Data EncryptionYou can use explicit capture to construct and enqueue row logical change records (row LCRs) for … when you construct the row LCRs. Therefore, when explicitly captured row LCRs are staged in a queue … , all of the columns in the row LCRs are decrypted. See Also: \"Explicit Capture by Applications\"

Streams Concepts and Administration, 11g Release 2 (11.2)

Advanced Apply Process Concepts

Dependency Detection, Rule-Based Transformations, and Apply Handlershandlers are configured for the apply process, LCRs are processed in the following order: The apply process … dequeues LCRs from its queue. The apply process runs rule-based transformations on LCRs, when … appropriate. The apply process detects dependencies between LCRs. The apply process passes LCRs

Database PL/SQL Packages and Types Reference, 11g Release 2 (11.2)

DBMS_APPLY_ADM

SET_SCHEMA_INSTANTIATION_SCN Procedureprecise control over which DDL logical change records (LCRs) for a schema are ignored and which DDL … LCRs are applied by an apply component. Syntax DBMS_APPLY_ADM.SET_SCHEMA_INSTANTIATION_SCN … Procedure and LCRs Instantiation SCNs and DDL LCRs The recursive Parameter The … Procedure LCR$_DDL_RECORD Type for

Database PL/SQL Packages and Types Reference, 11g Release 2 (11.2)

DBMS_STREAMS_ADM

Overviewlevel. These rules support logical change records (LCRs), which include row LCRs and data definition … language (DDL) LCRs. This package also contains subprograms for creating message rules for specific

Database PL/SQL Packages and Types Reference, 11g Release 2 (11.2)

DBMS_CAPTURE_ADM

INCLUDE_EXTRA_ATTRIBUTE ProcedureThis procedure includes or excludes an extra attribute in logical change records (LCRs) captured by … included in or excluded from LCRs captured by the capture process or synchronous capture. The following … included in DDL LCRs, or in row LCRs for index-organized tables. The type is VARCHAR2. serial# The serial

Database PL/SQL Packages and Types Reference, 11g Release 2 (11.2)

DBMS_STREAMS

CONVERT_LCR_TO_XML Functionobject that conforms to the XML schema for LCRs. The LCR can be a row LCR or a DDL LCR. See Also … : Oracle Streams Concepts and Administration for more information about the XML schema for LCRs Syntax

Database Reference, 11g Release 2 (11.2)

V$XSTREAM_TRANSACTION

V$XSTREAM_TRANSACTIONmany LCRs are being processed in each transaction. This view only contains information about captured … LCRs. It does not contain information about user-enqueued LCRs or user messages. This view only shows … information about LCRs that are being processed because they satisfied the rule sets for the … in transactions

Streams Concepts and Administration, 11g Release 2 (11.2)

How Oracle Streams Works with Other Database Components

Manual Dequeue and Transparent Data EncryptionA user or application can dequeue implicitly captured row LCRs that contain columns encrypted using … transparent data encryption. When row LCRs with encrypted columns are dequeued, the encrypted

Streams Extended Examples, 11g Release 2 (11.2)

Logical Change Records with LOBs Example

5 Logical Change Records with LOBs ExampleLCRs that contain LOBs. This chapter contains this topic: Example Script for Constructing and Enqueuing LCRs Containing LOBs

Streams Concepts and Administration, 11g Release 2 (11.2)

Oracle Streams Information Capture

Types of Information Captured with Oracle StreamsThe following types of information can be captured with Oracle Streams: Logical Change Records (LCRs) User Messages

Streams Concepts and Administration, 11g Release 2 (11.2)

How Oracle Streams Works with Other Database Components

Apply Processes and Transparent Data EncryptionAn apply process can dequeue and process implicitly captured row logical change records (row LCRs … ) that contain columns encrypted using transparent data encryption. When row LCRs with encrypted … columns are dequeued by an apply process, the encrypted columns are decrypted. These row LCRs with … . When row LCRs

Database Reference, 11g Release 2 (11.2)

ALL_APPLY_ERROR

ALL_APPLY_ERRORprocess can access all of the LCRs in the error transaction. When the ERROR_TYPE is NULL, manage the … ERROR if the apply process cannot access all of the LCRs in the error transaction. This error type … typically means that the apply process was applying LCRs in a large transaction. When the ERROR_TYPE is … . ERROR_POSITION Foot 2 

Database Reference, 11g Release 2 (11.2)

DBA_APPLY_ERROR

DBA_APPLY_ERRORtransaction ERROR_TYPE Foot 1  VARCHAR2(23)   NULL if the apply process can access all of the LCRs in the … the LCRs in the error transaction. This error type typically means that the apply process was … applying LCRs in a large transaction. When the ERROR_TYPE is EAGER ERROR, manage the error transaction … apply process can access

Database PL/SQL Packages and Types Reference, 11g Release 2 (11.2)

DBMS_APPLY_ADM

SET_GLOBAL_INSTANTIATION_SCN Procedure… This procedure gives you precise control over which DDL logical change records (DDL LCRs) from a … source database are ignored and which DDL LCRs are applied by an apply component. Syntax … LCRs The recursive Parameter Considerations for the SET_GLOBAL_INSTANTIATION_SCN Procedure The … SET_TABLE_INSTANTIATION_SCN Procedure

Database Reference, 11g Release 2 (11.2)

V$XSTREAM_OUTBOUND_SERVER

V$XSTREAM_OUTBOUND_SERVERdisplays statistics about an outbound server. An outbound server sends LCRs to the XStream client … -system process that sends LCRs to the client application SERVER_NAME VARCHAR2(30) Name of the outbound … because there are no LCRs to send to the XStream client application. GET TRANSACTIONS - Receiving … XStream client application.

Streams Concepts and Administration, 11g Release 2 (11.2)

Oracle Streams Information Consumption

The Source of Messages Applied by an Apply Processoriginated at multiple databases. However, a single apply process can apply captured LCRs from only … one source database. Similarly, a single apply process can apply persistent LCRs captured by a … synchronous capture from only one source database. Applying these LCRs requires knowledge of the … LCRs from multiple

Streams Concepts and Administration, 11g Release 2 (11.2)

Oracle Streams Information Consumption

Table 4-1 Information Consumption Options with Oracle StreamsProcess Continually and automatically when enabled Captured LCRs Persistent LCRs Persistent user messages … You want to dequeue and process captured LCR s. You want to dequeue persistent LCRs or persistent … Messaging Client When invoked by an application Persistent LCRs Persistent user messages You want to use

Database Reference, 11g Release 2 (11.2)

V$STREAMS_MESSAGE_TRACKING

V$STREAMS_MESSAGE_TRACKINGdisplays information about LCRs tracked through the stream that are processed by each Streams … LCRs is tracked in memory, and this view is populated with information about the LCRs. Currently

Streams Replication Administrator's Guide, 11g Release 2 (11.2)

Oracle Streams Heterogeneous Information Sharing

Change Capture in a Non-Oracle to Oracle EnvironmentLCRs and enqueuing the LCRs at the Oracle database, the application is completely responsible for … change capture. Therefore, the application must construct LCRs that represent changes at the non-Oracle … database and then enqueue these LCRs into the queue at the Oracle database. The application can … the transactions

Streams Concepts and Administration, 11g Release 2 (11.2)

How Oracle Streams Works with Other Database Components

Propagations and Network Data EncryptionA propagation can propagate row logical change records (row LCRs) that contain changes to columns … that were encrypted using network data encryption. When a propagation propagates row LCRs with … encrypted columns, the encrypted columns are decrypted while the row LCRs are transferred over the network

Streams Concepts and Administration, 11g Release 2 (11.2)

How Oracle Streams Works with Other Database Components

Queues and Transparent Data EncryptionA persistent queue can store row logical change records (row LCRs) captured by a synchronous … capture, and these row LCRs can contain changes to columns that were encrypted using transparent data … encryption. The row LCRs remain encrypted while they are stored in the persistent queue. Explicitly … captured row LCRs

Streams Concepts and Administration, 11g Release 2 (11.2)

How Oracle Streams Works with Other Database Components

Messaging Clients and Transparent Data EncryptionA messaging client can dequeue implicitly captured row LCRs that contain columns encrypted using … transparent data encryption. When row LCRs with encrypted columns are dequeued by a messaging client

Streams Concepts and Administration, 11g Release 2 (11.2)

Combined Capture and Apply Optimization

About Combined Capture and Apply Optimizationreceiver enqueues the LCRs into the buffered queue portion of the destination queue, and an apply … process dequeues the LCRs. This optimization is called combined capture and apply.

Streams Concepts and Administration, 11g Release 2 (11.2)

How Oracle Streams Works with Other Database Components

Synchronous Capture and Transparent Data Encryptiondata encryption. Encrypted columns in row logical change records (row LCRs) captured by a synchronous … capture remain encrypted when the row LCRs are staged in a persistent queue. See Also: \"Implicit Capture with Synchronous Capture\"

Streams Concepts and Administration, 11g Release 2 (11.2)

Monitoring Oracle Streams Implicit Capture

Viewing the Extra Attributes Captured by Implicit Captureattributes in LCRs. The following query displays the extra attributes included in the LCRs captured by … ' FORMAT A15 COLUMN INCLUDE HEADING 'Include Attribute in LCRs?' FORMAT A30 SELECT CAPTURE_NAME … the following: Capture Process or Attribute Name Include Attribute in LCRs? Synchronous Capture … includes the

Streams Concepts and Administration, 11g Release 2 (11.2)

Oracle Streams Information Capture

Types of Messages That Can Be Enqueued Explicitlythey can be LCR s. This section contains these topics: User Messages Logical Change Records (LCRs … Change Records (LCRs) and Messaging An application can construct and enqueue LCRs into an ANYDATA … queue. Row LCRs describe the results of DML changes, and DDL LCRs describe DDL changes. Typically, LCRs

Streams Concepts and Administration, 11g Release 2 (11.2)

Advanced Apply Process Concepts

Low-Watermark and High-Watermark for an Apply ProcessThe low-watermark for an apply process is the system change number (SCN) up to which all LCRs have … been applied. That is, LCRs that were committed at an SCN less than or equal to the low-watermark … number have definitely been applied, but some LCRs that were committed with a higher SCN also might … capture process. The high-watermark

Database Reference, 11g Release 2 (11.2)

ALL_XSTREAM_OUTBOUND

ALL_XSTREAM_OUTBOUNDLCRs CAPTURE_NAME VARCHAR2(30)   Name of the Streams capture process SOURCE_DATABASE VARCHAR2(128 … . COMMITTED_DATA_ONLY Footref 1 VARCHAR2(3)   YES if the outbound server can send only LCRs in committed … transaction with no rollbacks. NO if the outbound server can send LCRs in transactions that have not

Database PL/SQL Packages and Types Reference, 11g Release 2 (11.2)

DBMS_STREAMS_HANDLER_ADM

Overviewchange records (row LCRs) that are dequeued by an apply process. A single statement DML handler can … procedure DML handlers provide custom processing of row changes that are encapsulated in row LCRs … in row LCRs. Typically, procedure DML handlers must manipulate ANYDATA values. A statement DML

Database PL/SQL Packages and Types Reference, 11g Release 2 (11.2)

DBMS_STREAMS

Overviewin redo entries or LCRs. See Also: Oracle Streams Concepts and Administration and Oracle Streams

Database PL/SQL Packages and Types Reference, 11g Release 2 (11.2)

DBMS_STREAMS

COMPATIBLE_9_2 Functionlogical change records (LCRs) to specify behavior based on compatibility. The constant value returned

Database PL/SQL Packages and Types Reference, 11g Release 2 (11.2)

DBMS_STREAMS

COMPATIBLE_11_2 Functionlogical change records (LCRs) to specify behavior based on compatibility. The constant value

Database PL/SQL Packages and Types Reference, 11g Release 2 (11.2)

DBMS_STREAMS

CONVERT_ANYDATA_TO_LCR_DDL Functionsubscriber for propagation of DDL LCRs from a ANYDATA queue to a SYS.LCR$_DDL_RECORD typed queue. See Also: Oracle Streams Advanced Queuing User's Guide

Database PL/SQL Packages and Types Reference, 11g Release 2 (11.2)

DBMS_STREAMS

CONVERT_ANYDATA_TO_LCR_ROW Functionsubscriber for propagation of row LCRs from a ANYDATA queue to a SYS.LCR$_ROW_RECORD typed queue. See Also: Oracle Streams Advanced Queuing User's Guide

Database Reference, 11g Release 2 (11.2)

ALL_APPLY_ERROR_MESSAGES

ALL_APPLY_ERROR_MESSAGESnumber is populated only for the LCR that raised the error. This field is NULL for the other LCRs in … other LCRs in the transaction. SOURCE_OBJECT_OWNER VARCHAR2(30)   Owner of the object at the source … name and value for old and/or new values in DML LCRs. For DDL LCRs, the content is the text of the

Database Reference, 11g Release 2 (11.2)

V$LOGMNR_STATS

V$LOGMNR_STATSby SQL Apply Rolled back txns seen LCRs delivered to client - Number of logical change records (LCRs … out logical change records (LCRs) pertaining to long-running transactions. The ratio of Bytes … , whereby it writes out logical change records (LCRs) pertaining to long-running transactions. Bytes rolled

Database PL/SQL Packages and Types Reference, 11g Release 2 (11.2)

DBMS_STREAMS

COMPATIBLE_10_1 Functionlogical change records (LCRs) to specify behavior based on compatibility. The constant value

Database PL/SQL Packages and Types Reference, 11g Release 2 (11.2)

DBMS_STREAMS

COMPATIBLE_11_1 Functionlogical change records (LCRs) to specify behavior based on compatibility. The constant value

Database PL/SQL Packages and Types Reference, 11g Release 2 (11.2)

DBMS_STREAMS_ADM

PURGE_SOURCE_CATALOG Procedure(LCRs) captured by the capture process for the object are or might be applied locally without … reinstantiating the object. LCRs captured by the capture process for the object are or might be forwarded … by the database without reinstantiating the object. Note: These conditions do not apply to LCRs that … were not created by the

Database PL/SQL Packages and Types Reference, 11g Release 2 (11.2)

DBMS_STREAMS

COMPATIBLE_10_2 Functionlogical change records (LCRs) to specify behavior based on compatibility. The constant value

Database PL/SQL Packages and Types Reference, 11g Release 2 (11.2)

DBMS_STREAMS

144 DBMS_STREAMSwhose rules include specifications for these binary tags in redo entries or LCRs. This chapter

Streams Replication Administrator's Guide, 11g Release 2 (11.2)

Oracle Streams Heterogeneous Information Sharing

Staging in a Non-Oracle to Oracle EnvironmentLCRs at the Oracle database. For example, suppose a single transaction contains three row changes … , and the custom application enqueues three row LCRs, one for each change, and then commits. With a … -time queue. A commit-time queue orders LCRs by approximate commit system change number (approximate … CSCN) of the transaction

Database Reference, 11g Release 2 (11.2)

ALL_XSTREAM_INBOUND

ALL_XSTREAM_INBOUNDif the inbound server can receive only LCRs in committed transactions from the XStream client … the inbound server can receive LCRs in transactions that have not yet committed. This mode is for

Database Reference, 11g Release 2 (11.2)

V$GG_APPLY_RECEIVER

V$GG_APPLY_RECEIVERclient Receiving LCRs Evaluating rules Enqueueing LCRS Waiting for memory Waiting for apply to read

Database Reference, 11g Release 2 (11.2)

ALL_APPLY_DML_HANDLERS

ALL_APPLY_DML_HANDLERSwhether LOB assembly is used for LOB columns in logical change records (LCRs) processed by the handler … ( Y ) or not ( N ) LOB assembly combines multiple LCRs for a LOB column resulting from a single row

Database Reference, 11g Release 2 (11.2)

V$XSTREAM_APPLY_RECEIVER

V$XSTREAM_APPLY_RECEIVERunapplied txns Waiting for message from client Waiting for LCR from client Receiving LCRs … Evaluating rules Enqueueing LCRS Waiting for memory Waiting for apply to read Waiting for client flush

Database PL/SQL Packages and Types Reference, 11g Release 2 (11.2)

DBMS_APPLY_ADM

CREATE_OBJECT_DEPENDENCY Procedurecommitted. An apply component uses the object identifier of the objects in the logical change records (LCRs … ) to detect dependencies. The apply component does not use column values in the LCRs to detect


Was this page helpful?