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 4223 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 2 (11.2)

Services for Microsoft Transaction Server Developer's Guide - Contents

ContentsConventions 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

Database PL/SQL Language Reference, 11g Release 2 (11.2)

PL/SQL Static SQL

Transaction ContextThe 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.

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

Managing Distributed Transactions

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 2 (11.2)

SET TRANSACTION

SET TRANSACTIONPurpose 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

Database PL/SQL Language Reference, 11g Release 2 (11.2)

PL/SQL Static SQL

Transaction VisibilityChanges 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

Database Reference, 11g Release 2 (11.2)

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 2 (11.2)

PL/SQL Static SQL

Transaction Processing and ControlA 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

Database PL/SQL Language Reference, 11g Release 2 (11.2)

PL/SQL Static SQL

SET TRANSACTION StatementYou 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 SQL Language Reference, 11g Release 2 (11.2)

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 2 (11.2)

Managing Distributed Transactions

Analyzing the Transaction DataIf 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.

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

Distributed Transactions Concepts

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

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

Managing Distributed Transactions

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 2 (11.2)

Distributed Transactions Concepts

Distributed Transaction Processing: Case Studytransaction actually commits What information is stored locally about the transaction

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

Managing Distributed Transactions

Manually Committing an In-Doubt TransactionBefore 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

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

Managing Distributed Transactions

Step 5: Commit the In-Doubt TransactionYou contact the administrator of the sales database, who manually commits the in-doubt transactiontransaction using the global ID: SQL> CONNECT SYS@warehouse.example.com AS SYSDBA SQL> COMMIT FORCE 'SALES.EXAMPLE.COM.55d1c563.1.93.29';

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

Managing Distributed Transactions

Manually Rolling Back an In-Doubt TransactionBefore 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

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

Managing Distributed Transactions

Manually Committing an In-Doubt Transaction: ExampleFigure 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

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

Managing Distributed Transactions

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 … -doubt ORA-02059: ORA_CRASH_TEST_7 in commit comment At this point, the in-doubt distributed transaction … appears in the DBA_2PC_PENDING

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

Distributed Database Concepts

Transaction Processing in a Distributed SystemA 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

Retail Data Model Reference, 11g Release 2 (11.2)

Oracle Retail Data Model Sample Reports Continued

TransactionReport Description of \"Figure 13-73 Store Traffic Week Report\" Transaction Transaction includes the