How do I narrow my search results?
After you submit your search query:
- On the Refine Search results page, select one or more categories of products or services from the left sidebar.
- 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
Contents → Accessibility 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
Transaction Timeouts → A 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
SET TRANSACTION → Purpose 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
transaction → Wait 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
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
Analyzing the Transaction Data → If you decide to force the transaction to complete, analyze available information with the following goals in mind.
Transaction Control Statements → The following are the supported transaction control statements: COMMIT ROLLBACK SAVEPOINT See Also
Look for Transaction Advice → transaction. 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
Simulating Distributed Transaction Failure → You 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
Look for Transaction Comments → transaction. 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
Transaction Control Statements → Transaction control statements manage changes made by DML statements. The transaction control … statements are: COMMIT ROLLBACK SAVEPOINT SET TRANSACTION SET CONSTRAINT All transaction control
Disabling and Enabling RECO → a 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 transaction … transaction table of each database. You can enable and disable RECO using the ALTER SYSTEM statement with the … force the failure
Forcing a Distributed Transaction to Fail → a 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.
Transaction Control Language (TCL) Statements → The 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
Determining the Global Transaction ID → The 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
Distributed Transaction Processing: Case Study → session 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
How a Distributed Transaction Commits → A 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
Stage 5: Commit Point Site Informs Global Coordinator of Commit → the 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.
Stage 6: Global and Local Coordinators Tell All Nodes to Commit → The 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
Stage 3: Global Coordinator Sends Prepare Response → locally 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