Results for LCRs


81 to 120 of 507 results. Prev  Next
Results per page:  20 |  40  | 60


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

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

DBMS_STREAMS

Summary of DBMS_STREAMS Subprograms) encapsulated in a ANYDATA object into an XML object that conforms to the XML schema for LCRs … CONVERT_XML_TO_LCR Function Converts an XML object that conforms to the XML schema for LCRs into a logical

Database Reference, 11g Release 2 (11.2)

ALL_XSTREAM_RULES

ALL_XSTREAM_RULES, the table name INCLUDE_TAGGED_LCR VARCHAR2(3)   Indicates whether to include tagged LCRs ( YES ) or … SOURCE_DATABASE VARCHAR2(128)   The name of the database where the LCRs originated ORIGINAL_RULE_CONDITION

Database Error Messages, 11g Release 2 (11.2)

ORA-24280 to ORA-28674

ORA-25304: Cannot use priority order queues for capture LCRsinstance. ORA-25304: Cannot use priority order queues for capture LCRs

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

Advanced Queue Concepts

Table 8-1 Apply Process Behavior for Transactional and Nontransactional QueuesMessage Type Transactional Queue Nontransactional Queue Captured LCRs Apply process preserves the … original transaction. Apply process preserves the original transaction. Persistent LCRs or Persistent … executed at the source database, use transactional queues to store the messages. Ensure that LCRs

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

Configuring Implicit Apply

Overview of Apply Process Creationchange records that were captured by a capture process are called captured LCRs, and they are always in … buffered queues. Therefore, if a single apply process applies LCRs that were captured by a capture … process, then it cannot apply persistent LCRs or persistent user messages. Alternatively, LCRs that … were

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

Managing Oracle Streams Information Consumption

Managing a DML HandlerDML handlers process row logical change records (row LCRs) dequeued by an apply process. There are … handler uses a collection of SQL statements to process row LCRs, while a procedure DML handler uses a PL … /SQL procedure to process row LCRs. This section contains instructions for managing a DML handler

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

Advanced Apply Process Concepts

How Dependent Transactions Are Appliedthe destination database, all of the LCRs in transaction A are applied before any LCRs in … applies the row LCRs in these transactions until it detects a row LCR that depends on a row LCR in … LCRs in the transaction with the lower commit system change number (CSCN) and commits this transaction … before it finishes

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

DBMS_STREAMS_ADM

Table 145-1 Common Parameters for Configuration Proceduresto a table, to logical change records (LCRs), or to user messages. An LCR represents either a row … represents a row change is a row LCR, and an LCR that represents a DDL change is a DDL LCR. LCRs can … Changes to Tables Propagation Rules for LCRs Propagation Rules for User Messages Apply Process Rules for … LCRs

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

Oracle Streams Restrictions

Unsupported Data Types for Apply HandlersStatement DML handlers cannot process LONG, LONG RAW, or nonassembled LOB column data in row LCRs … . However, statement DML handlers can process LOB column data in row LCRs that have been constructed … handlers and error handlers cannot process LONG or LONG RAW column data in row LCRs. However, procedure DML … handlers and error

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

Administering Oracle Streams Replication

Administering Oracle Streams Replication\" Chapter 13, \"Comparing and Converging Data\" Chapter 14, \"Managing Logical Change Records (LCRs)\"

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

How Rules Are Used in Oracle Streams

Table 5-2 Types of Tasks and Rule Levelsspecified table, convert them into logical change records (LCRs), and enqueue them. If the schema rule … schema, convert them into LCRs, and enqueue them. If the global rule is in a negative rule set, then … into LCRs, and enqueue them. Capture with a synchronous capture If the table rule is in a positive … logical change records

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

Monitoring Oracle Streams Apply Processes

Displaying Detailed Information About Apply Errorsabout LCRs, but you can extend them to display information about any non-LCR message s used in your … Procedure that Prints a Specified LCR Create a Procedure that Prints All the LCRs in the Error … Queue Create a Procedure that Prints All the Error LCRs for a Transaction Note: These scripts display … only the first 253 characters

Database Reference, 11g Release 2 (11.2)

V$XSTREAM_CAPTURE

V$XSTREAM_CAPTUREdisplays information about each capture process that sends LCRs to an XStream outbound server. Note … : This view does not display information about capture processes that send LCRs to Oracle Streams … - Unable to enqueue LCRs either because of low memory or because propagations and outbound servers are … that is used to reduce

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

Configuring Implicit Apply

Creating an Apply Process Using DBMS_APPLY_ADMpackage: Creating an Apply Process for Captured LCRs with DBMS_APPLY_ADM Creating an Apply Process … for Persistent LCRs with DBMS_APPLY_ADM See Also: \"Change Apply in an Oracle to Non-Oracle

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

DBMS_STREAMS_ADM

SET_RULE_TRANSFORM_FUNCTION Procedure-to-many functions only can operate on row logical change records (row LCRs). They cannot operate on … DDL LCRs. Row LCRs returned by a one-to-many function cannot contain piecewise LOB, LONG, or LONG … RAW operations. The one-to-many function must return row LCRs in the correct order. The order of row … LCRs

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

Oracle Streams Information Capture

Table 2-6 Information Capture Options with Oracle StreamsStreams Capture Process Mining of Redo Log Captured LCRs Buffered Queue You want to capture changes … Capture Internal Mechanism Persistent LCRs Persistent Queue You want to capture DML changes to a … by Applications Manual Message Creation and Enqueue Buffered LCRs Persistent LCRs Buffered User … that will be

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

Advanced Apply Process Concepts

Dependencies and Constraintsdetects dependencies between row LCRs, assuming constraints are defined for the database objects at the … by database constraints. When an apply process is applying a transaction that contains row LCRs that … depend on row LCRs in another transaction, the apply process ensures that the row LCRs are applied … dependencies.

Database Reference, 11g Release 2 (11.2)

V$PROPAGATION_SENDER

V$PROPAGATION_SENDERsender process: Initializing Initializing propagation receiver Browsing LCRs Evaluating rules … Dequeueing LCRs Sending LCRs Waiting for apply to be enabled Waiting for apply database to start Waiting

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

DBMS_CAPTURE_ADM

Table 32-17 Capture Process Parameterscapture process captures ID key logical change records (LCRs). If N, then the capture process does not … capture ID key LCRs. Capture processes do not fully support capturing changes to some data types … from the redo log. ID key LCRs enable an XStream configuration to capture these changes and process … LCRs

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

DBMS_APPLY_ADM

CREATE_APPLY Procedureprocedure. ddl_handler A user-defined procedure that processes DDL logical change record (DDL LCRs) in the … queue for the apply component. All applied DDL LCRs commit automatically. Therefore, if a DDL … used to track LCRs. The tag is relevant only if a capture process at the database where the apply … apply_captured Either TRUE


Was this page helpful?