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 → Conventions What's New in Oracle Services for Microsoft Transaction Server Oracle Database 11 g Release … 2 (11.2) New Features 1 Using Microsoft Transaction Server with Oracle Database Microsoft … Transaction Server Overview Microsoft Transaction Server and Oracle Integration Overview Oracle Services for … Microsoft
Transaction Context → The main transaction shares its context with nested routines, but not with autonomous transactions … transaction context. When an autonomous routine invokes a nonautonomous routine, the routines share the same transaction context.
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 … to the transaction. A transaction implicitly begins with any operation that obtains a TX lock: When a … transaction is explicitly started with a SET TRANSACTION statement or the DBMS_TRANSACTION
Transaction Visibility → Changes made by an autonomous transaction become visible to other transactions when the autonomous … transaction commits. These changes become visible to the main transaction when it resumes, if its … transaction to SERIALIZABLE, changes made by its autonomous transactions are not visible to the main … transaction
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
Transaction Processing and Control → A transaction is a sequence of one or more SQL statements that Oracle Database treats as a unit … transactions, see Oracle Database Concepts. Transaction processing is an Oracle Database feature that lets … of data and that all changes are applied in the right order. For more information about transaction … Implicit Rollbacks
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
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
Analyzing the Transaction Data → If you decide to force the transaction to complete, analyze available information with the … node that has either committed or rolled back the transaction. If you can find a node that has already … resolved the transaction, then you can follow the action taken at that node. Look for Transaction … distributed transaction.
Transaction Control Statements → The following are the supported transaction control statements: COMMIT ROLLBACK SAVEPOINT See Also
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
Distributed Transaction Processing: Case Study → transaction actually commits What information is stored locally about the transaction
Manually Committing an In-Doubt Transaction → Before attempting to commit the transaction, ensure that you have the proper privileges. Note the … following requirements: User Committing the Transaction Privilege Required You FORCE TRANSACTION … Another user FORCE ANY TRANSACTION Committing Using Only the Transaction ID The following SQL statement
Step 5: Commit the In-Doubt Transaction → You contact the administrator of the sales database, who manually commits the in-doubt transaction … transaction using the global ID: SQL> CONNECT SYS@warehouse.example.com AS SYSDBA SQL> COMMIT FORCE 'SALES.EXAMPLE.COM.55d1c5184.108.40.206';
Manually Rolling Back an In-Doubt Transaction → Before attempting to roll back the in-doubt distributed transaction, ensure that you have the … proper privileges. Note the following requirements: User Committing the Transaction Privilege Required … You FORCE TRANSACTION Another user FORCE ANY TRANSACTION The following SQL statement rolls back an in … -doubt
Manually Committing an In-Doubt Transaction: Example → Figure 35-1, illustrates a failure during the commit of a distributed transaction. In this failure … the transaction. Inventory data is locked and cannot be accessed because the in-doubt transaction is … critical to other transactions. Further, the locks must be held until the in-doubt transaction either commits or rolls
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 … -doubt ORA-02059: ORA_CRASH_TEST_7 in commit comment At this point, the in-doubt distributed transaction … appears in the DBA_2PC_PENDING
Transaction Processing in a Distributed System → A transaction is a logical unit of work constituted by one or more SQL statements executed by a … single user. A transaction begins with the user's first executable SQL statement and ends when it is … committed or rolled back by that user. A remote transaction contains only statements that access a … single remote node. A distributed