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 transaction


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


Services for Microsoft Transaction Server Developer's Guide for Microsoft Windows, 11g Release 1 (11.1)

Services for Microsoft Transaction Server Developer's Guide - Contents

ContentsAccessibility Related Documents Conventions 1 Using Microsoft Transaction Server with Oracle Database … 1.1 Microsoft Transaction Server Overview 1.1.1 Oracle Services for Microsoft Transaction Server … Support for Serializable Transactions 1.1.2 Oracle Services for Microsoft Transaction Server Support for … DTC

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

Data Access Failures Due to Locks

Transaction TimeoutsA DML statement that requires locks on a remote database can be blocked if another transaction own … database returns this error message to the user: ORA-02049: time-out: distributed transaction waiting … for lock Because the transaction did not modify data, no actions are necessary as a result of the

Database SQL Language Reference, 11g Release 1 (11.1)

SET TRANSACTION

SET TRANSACTIONPurpose Use the SET TRANSACTION statement to establish the current transaction as read-only or read … /write, establish its isolation level, or assign it to a specified rollback segment. A transaction … issued When a SELECT... FOR UPDATE statement is issued When a transaction is explicitly started with … a SET

Database Reference, 11g Release 1 (11.1)

Descriptions of Wait Events

transactionWait for a blocking transaction to be rolled back. Continue waiting until the transaction has been … transaction count The number of times that the session has waited on this transaction

Database PL/SQL Language Reference, 11g Release 1 (11.1)

Using Static SQL

Setting Transaction Properties (SET TRANSACTION Statement)You use the SET TRANSACTION statement to begin a read-only or read/write transaction, establish an … isolation level, or assign your current transaction to a specified rollback segment. Read-only … read-only transaction, all queries refer to the same snapshot of the database, providing a multi … commit or rollback

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

Deciding How to Handle In-Doubt Transactions

Analyzing the Transaction DataIf you decide to force the transaction to complete, analyze available information with the following goals in mind.

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

What Are Distributed Transactions?

Transaction Control StatementsThe following are the supported transaction control statements: COMMIT ROLLBACK SAVEPOINT See Also

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

Deciding How to Handle In-Doubt Transactions

Look for Transaction Advicetransaction. An application can prescribe advice about whether to force the commit or force the rollback of … separate parts of a distributed transaction with the ADVISE clause of the ALTER SESSION statement … recent DML statement executed at that database in the current transaction. For example, consider a … distributed transaction

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

Simulating Distributed Transaction Failure

Simulating Distributed Transaction FailureYou can force the failure of a distributed transaction for the following reasons: To observe RECO … automatically resolving the local portion of the transaction To practice manually resolving in-doubt

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

Deciding How to Handle In-Doubt Transactions

Look for Transaction Commentstransaction. Comments are included in the COMMENT clause of the COMMIT statement, or if transaction … naming is used, the transaction name is placed in the TRAN_COMMENT field when the transaction is … committed. For example, the comment of an in-doubt distributed transaction can indicate the origin of

Database SQL Language Reference, 11g Release 1 (11.1)

Types of SQL Statements

Transaction Control StatementsTransaction control statements manage changes made by DML statements. The transaction control … statements are: COMMIT ROLLBACK SAVEPOINT SET TRANSACTION SET CONSTRAINT All transaction control

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

Simulating Distributed Transaction Failure

Disabling and Enabling RECOa node attempts to recover the local portion of an in-doubt distributed transaction. RECO can use an … existing connection or establish a new connection to other nodes involved in the failed transactiontransaction table of each database. You can enable and disable RECO using the ALTER SYSTEM statement with the … force the failure

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

Simulating Distributed Transaction Failure

Forcing a Distributed Transaction to Faila failure during the two-phase commit phases of a distributed transaction, include the following … both nodes are updated: COMMIT COMMENT 'ORA-2PC-CRASH-TEST-7'; ORA-02054: transaction 1.93.29 in … transaction appears in the DBA_2PC_PENDING view. If enabled, RECO automatically resolves the transaction.

Database PL/SQL Language Reference, 11g Release 1 (11.1)

Using Static SQL

Transaction Control Language (TCL) StatementsThe database is transaction oriented; that is, the database uses transactions to ensure data … integrity. A transaction is a series of SQL data manipulation statements that does a logical unit of work … not to allow one operation to succeed while the other fails. At the end of a transaction that makes … fails in the middle of

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

Manually Committing an In-Doubt Transaction: Example

Determining the Global Transaction IDThe global transaction ID is the common transaction ID that is the same on every node for a … distributed transaction. It is of the form: global_database_name. hhhhhhhh.local _ transaction_id where … local transaction ID assigned on the global coordinator. Note that the last portion of the global … transaction

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

Distributed Transaction Processing: Case Study

Distributed Transaction Processing: Case Studysession tree How a commit point site is determined When prepare messages are sent When a transaction … actually commits What information is stored locally about the transaction

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

Session Trees for Distributed Transactions

How a Distributed Transaction CommitsA distributed transaction is considered committed after all non-commit-point sites are prepared … , and the transaction has been actually committed at the commit point site. The redo log at the commit … point site is updated as soon as the distributed transaction is committed at this node. Because the … commit point log contains

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

Distributed Transaction Processing: Case Study

Stage 5: Commit Point Site Informs Global Coordinator of Committhe transaction has committed. Because the commit point site and global coordinator are the same node … in this example, no operation is required. The commit point site knows that the transaction is … transaction has been committed on all other nodes involved in the distributed transaction.

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

Distributed Transaction Processing: Case Study

Stage 6: Global and Local Coordinators Tell All Nodes to CommitThe committing of the transaction by all the nodes in the transaction involves the following steps … to commit, and so on. Each node, including the global coordinator, commits the transaction and … held locally for that transaction are released. In Figure 32-10, sales.acme.com, which is both the … commit point

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

Distributed Transaction Processing: Case Study

Stage 3: Global Coordinator Sends Prepare Responselocally dependent part of the transaction and can record the commit information in its local redo log … coordinator tells all nodes to roll back the transaction, and the operation is completed. If all nodes asked … transaction. Figure 32-9 Sending and Acknowledging the Prepare Message Description of \"Figure 32-9 Sending and Acknowledging