You are using an outdated browser. Please upgrade to the latest version for the best experience.
How do I narrow my search results?

After you submit your search query:

  1. On the Refine Search results page, select one or more categories of products or services from the left sidebar.
  2. Then for a category with search results, click Select to choose your product and release filters, and then click OK.

For search queries that contain multiple words, surround the query with quotes, and then resubmit your query. Example: "database cloud service"

How do I find the documentation for my product or service?

From the home page, click the technology categories for your products or services. If you do not know which category to pick, try the following features:

  • Click the Find a product tab and search for your product or service.
  • Click Browse All Products & Services at the bottom of the home page to view an alphabetical listing of products and services.
  • Apple Safari: Version 6
  • Google Chrome: Version 29 and later
  • Mozilla Firefox: Version 24 and later
  • Microsoft Internet Explorer: Version 9 and later
Results for two-phase commit


1 to 20 of 574 results. Previous page Prev  Next next page
Results per page:   20  | 40 | 60


Database Administrator's Guide, 11g Release 1 (11.1)

Two-Phase Commit Mechanism

Case Conditions Consequenceperform two-phase commit. Changes by other transactions do not degrade global transaction-level read … message indicates that the node will not participate in the commit phase. There are three cases in … , the commit phase completes faster because the database eliminates

Database Administrator's Guide, 11g Release 1 (11.1)

Two-Phase Commit Mechanism

Guaranteeing Global Database Consistency, global time-based recovery can also be completed. During the prepare phase, the database determines … high SCN at the commit point site. The commit SCN is then sent to all prepared nodes with the commit

Database Administrator's Guide, 11g Release 1 (11.1)

Two-Phase Commit Mechanism

Types of Responses in the Prepare PhaseWhen a node is told to prepare, it can respond in the following ways: Response Meaning Prepared Data on the node has been modified by a statement in the distributed transaction, and the node has successfully prepared. Read-only No data on the node has been, or can be, modified (only queried), so no preparation is necessary. Abort The node cannot successfully prepare.

Database Administrator's Guide, 11g Release 1 (11.1)

Two-Phase Commit Mechanism

Commit PhaseThe second phase in committing a distributed transaction is the commit phase. Before this phase … occurs, all nodes other than the commit point site referenced in the distributed transaction have … guaranteed that they are prepared, that is, they have the necessary resources to commit

Database Administrator's Guide, 11g Release 1 (11.1)

Two-Phase Commit Mechanism

Steps in the Commit PhaseThe commit phase consists of the following steps: The global coordinator instructs the commit point … global coordinator that they have committed. When the commit phase is complete, the data on all nodes of the distributed system is consistent. … site to commit. The commit

Database Administrator's Guide, 11g Release 1 (11.1)

Two-Phase Commit Mechanism

Prepare PhaseThe first phase in committing a distributed transaction is the prepare phase. In this phase, the … database does not actually commit or roll back the transaction. Instead, all nodes referenced in a … distributed transaction (except the commit point site, described in the \"Commit Point

Database Administrator's Guide, 11g Release 1 (11.1)

Two-Phase Commit Mechanism

Steps in the Prepare Phaseeither all commit or all roll back the transaction at the same logical time. Steps in the Prepare Phase … To complete the prepare phase, each node excluding the commit point site performs the following steps … commit. The node checks to see whether the transaction changes data on itself or its descendants.

Database Administrator's Guide, 11g Release 1 (11.1)

Two-Phase Commit Mechanism

Two-Phase Commit Mechanismdatabase ensures the integrity of data in a distributed transaction using the two-phase commit … transaction) using the two-phase commit mechanism. This mechanism is completely transparent, requiring no … nodes to promise to commit or roll back the transaction. During

Database Administrator's Guide, 11g Release 1 (11.1)

Two-Phase Commit Mechanism

Forget PhaseAfter the participating nodes notify the commit point site that they have committed, the commit … global coordinator that all nodes have committed, the commit point site erases status information … about this transaction. The commit point site informs the global coordinator that it has erased the

Database Administrator's Guide, 11g Release 1 (11.1)

Transaction Processing in a Distributed System

Two-Phase Commit Mechanismdatabase two-phase commit mechanism guarantees that all database servers participating in a distributed … transaction either all commit or all roll back the statements in the transaction. A two-phase … information about the Oracle Database two-phase

Database Concepts, 11g Release 1 (11.1)

Transaction Management

The Two-Phase Commit Mechanisma distributed database. A two-phase commit mechanism guarantees that all database servers … two-phase commit mechanism also protects implicit DML operations performed by integrity constraints … , remote procedure calls, and triggers. The Oracle Database two-phase

Database Administrator's Guide, 11g Release 1 (11.1)

Deciding How to Handle In-Doubt Transactions

Discovering Problems with a Two-Phase Committree (that is, all commit or all roll back) after the network or system failure is resolved. In … extended outages, however, you can force the commit or rollback of a transaction to release any locked

Database Administrator's Guide, 11g Release 1 (11.1)

In-Doubt Transactions

Failure During the Commit Phasefailure situations and how the database resolves intervening failures during two-phase commit … Figure 32-6 illustrates the sequence of events when there is a failure during the commit phase of a … distributed transaction: Figure 32-6 Failure During Commit Phase Description

Database Gateway Installation and Configuration Guide for Microsoft Windows, 11g Release 1 (11.1)

Configuring Oracle Database Gateway for Informix

Configure Two-Phase Commitprepared the transaction. Only one gateway instance can participate in an Oracle two-phase commit … Administrator's Guide for information about the two-phase commit process. To enable the COMMIT_CONFIRM … Log Table The log table, called HS_TRANSACTION_LOG, is where two-phase

Database Gateway Installation and Configuration Guide for Microsoft Windows, 11g Release 1 (11.1)

Configuring Oracle Database Gateway for DRDA

Configure Two-Phase Commit(Universal Database)\". Create the ORACLE2PC table: $ db2 -tf o2pc.sql Commit the transaction: $ db2 … 'COMMIT' Optionally, verify that the table was created under the correct userĀ ID: $ db2 'LIST TABLES … FOR USER' $ db2 'COMMIT' Disconnect from the session: $ db2 'DISCONNECT CURRENT' If connecting to DB2

Database Gateway Installation and Configuration Guide for Microsoft Windows, 11g Release 1 (11.1)

Configuring Oracle Database Gateway for Sybase

Configure Two-Phase Commitprepared the transaction. Only one gateway instance can participate in an Oracle two-phase commit … Guide for information about the two-phase commit process. To enable the COMMIT_CONFIRM transaction … Table The log table, called HS_TRANSACTION_LOG, is where two-phase

Database Gateway Installation and Configuration Guide for Microsoft Windows, 11g Release 1 (11.1)

Configuring Oracle Database Gateway for Teradata

Configure Two-Phase Commitprepared the transaction. Only one gateway instance can participate in an Oracle two-phase commit … Administrator's Guide for information about the two-phase commit process. To enable the COMMIT_CONFIRM … Log Table The log table, called HS_TRANSACTION_LOG, is where two-phase

Database Gateway Installation and Configuration Guide for Microsoft Windows, 11g Release 1 (11.1)

Configuring Oracle Database Gateway for SQL Server

Configure Two-Phase Commitsuccessfully prepared the transaction. Only one gateway instance can participate in an Oracle two-phase commit … Administrator's Guide for information about the two-phase commit process. To enable the COMMIT_CONFIRM … Transaction Log Table The log table, called HS_TRANSACTION_LOG, is

Database Gateway Installation and Configuration Guide for AIX 5L Based Systems (64-Bit), HP-UX PA-RISC (64-Bit), HP-UX Itanium, Solaris Operating System (SPARC 64-Bit), Linux x86, and Linux x86-64, 11g Release 1 (11.1)

Configuring Oracle Database Gateway for SQL Server

9.5 Configure Two-Phase Commitsuccessfully prepared the transaction. Only one gateway instance can participate in an Oracle two-phase commit … Administrator's Guide for information about the two-phase commit process. To enable the COMMIT_CONFIRM … Transaction Log Table The log table, called HS_TRANSACTION_LOG, is

Database Gateway Installation and Configuration Guide for AIX 5L Based Systems (64-Bit), HP-UX PA-RISC (64-Bit), HP-UX Itanium, Solaris Operating System (SPARC 64-Bit), Linux x86, and Linux x86-64, 11g Release 1 (11.1)

Configuring Oracle Database Gateway for Teradata

7.5 Configure Two-Phase Commitprepared the transaction. Only one gateway instance can participate in an Oracle two-phase commit … Administrator's Guide for information about the two-phase commit process. To enable the COMMIT_CONFIRM … Log Table The log table, called HS_TRANSACTION_LOG, is where two-phase