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


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

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 Concepts, 11g Release 2 (11.2)

Transactions

Transaction NamesA transaction name is an optional, user-specified tag that serves as a reminder of the work that … the transaction is performing. You name a transaction with the SET TRANSACTION... NAME statement … , which if used must be first statement of the transaction. In Table 10-1, the first transaction

Database Concepts, 11g Release 2 (11.2)

Introduction to Oracle Database

Transaction ManagementOracle Database is designed as a multiuser database. The database must ensure that multiple users can work concurrently without corrupting one another's data.

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 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 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 Concepts, 11g Release 2 (11.2)

SQL

Transaction Control Statementsnot retrieve rows before inserting a row. See Also: \"Virtual Private Database (VPD)\" Transaction … Control Statements Transaction control statements manage the changes made by DML statements and group … DML statements into transactions. These statements enable you to: Make changes to a transaction … permanent ( COMMIT ). Undo

Database Concepts, 11g Release 2 (11.2)

Transactions

Overview of Transaction ControlTransaction control is the management of changes made by DML statements and the grouping of DML … statements into transactions. In general, application designers are concerned with transaction control … so that work is accomplished in logical units and data is kept consistent. Transaction control … involves using the following

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 Concepts, 11g Release 2 (11.2)

Transactions

Structure of a TransactionFigure 10-1 A Banking Transaction Description of \"Figure 10-1 A Banking Transaction\" Structure of … a Transaction A database transaction consists of one or more statements. Specifically, a … transaction consists of one of the following: One or more data manipulation language (DML) statements that

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 Concepts, 11g Release 2 (11.2)

Oracle Transaction Management

Oracle Transaction ManagementPart III Oracle Transaction Management This part contains the following chapters: Chapter 10

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

PL/SQL Static SQL

Autonomous TransactionsAn autonomous transaction is an independent transaction started by another transaction, the main … transaction. Autonomous transactions do SQL operations and commit or roll back, without committing or … rolling back the main transaction. Figure 6-1 shows how control flows from the main transaction

Database Concepts, 11g Release 2 (11.2)

Glossary

transactionLogical unit of work that contains one or more SQL statements. All statements in a transaction