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 TRANSACTIONS


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


Database PL/SQL Language Reference, 12c Release 1 (12.1)

PL/SQL Static SQL

Autonomous Transactionsdifferent transactions try to modify the same row does one transaction wait for the other to complete. The … COMMIT; END LOOP; CLOSE c1; END; / Autonomous Transactions An autonomous transaction is an … independent transaction started by another transaction, the main transaction. Autonomous transactions do SQL … back again. The

Database PL/SQL Language Reference, 12c Release 1 (12.1)

PL/SQL Static SQL

Controlling Autonomous Transactionsrollback comprise the current transaction. To control autonomous transactions, use these statements … Rolling Back Autonomous Transactions Savepoints Avoiding Errors with Autonomous Transactions

Database PL/SQL Language Reference, 12c Release 1 (12.1)

PL/SQL Static SQL

Advantages of Autonomous Transactionson, even if the main transaction rolls back. Autonomous transactions help you build modular, reusable … software components. You can encapsulate autonomous transactions in stored subprograms. An invoking

Database PL/SQL Language Reference, 12c Release 1 (12.1)

PL/SQL Error Handling

Retrying Transactions After Handling ExceptionsTo retry a transaction after handling an exception that it raised, use this technique: Enclose the transaction in a sub-block that has an exception-handling part. In the sub-block, before the transaction starts, mark a savepoint. In the exception-handling part of the sub-block, put an exception handler that rolls back to the savepoint and then tries to correct the problem. Put the sub-block inside

Database Concepts, 12c Release 1 (12.1)

Introduction to Oracle Database

Transactionsfor transactions is a funds transfer from a savings account to a checking account. The transfer … transaction from executing, then the other statements must be rolled back. Transactions are one feature … principle of a transaction is \"all or nothing\": an atomic operation succeeds or fails as a whole. See Also: \" Transactions \"

Database Concepts, 12c Release 1 (12.1)

Transactions

10 TransactionsThis chapter defines a transaction and describes how the database processes transactions. This … chapter contains the following sections: Introduction to Transactions Overview of Transaction Control … Overview of Transaction Guard Overview of Application Continuity Overview of Autonomous Transactions Overview of Distributed Transactions

Database Concepts, 12c Release 1 (12.1)

Transactions

Sample Transaction: Account Debit and CreditTo illustrate the concept of a transaction, consider a banking database. When a customer transfers money from a savings account to a checking account, the transaction must consist of three separate operations: Decrement the savings account Increment the checking account Record the transaction in the transaction journal Oracle Database must allow for two situations. If all three SQL statements maintain

Database Concepts, 12c Release 1 (12.1)

Transactions

SavepointsA savepoint is a user-declared intermediate marker within the context of a transaction. Internally, the savepoint marker resolves to an SCN. Savepoints divide a long transaction into smaller parts. If you use savepoints in a long transaction, then you have the option later of rolling back work performed before the current point in the transaction but after a declared savepoint within the transaction.

Database Concepts, 12c Release 1 (12.1)

Transactions

Application Continuity Architecturelost transactions and potentially diverged Violates protocols Fails to reproduce the same client

Database Concepts, 12c Release 1 (12.1)

Transactions

Overview of Distributed TransactionsA distributed database is a set of databases in a distributed system that can appear to applications as a single data source. A distributed transaction is a transaction that includes one or more statements that update data on two or more distinct nodes of a distributed database, using a schema object called a database link. A database link describes how one database instance can log in to another

Database Concepts, 12c Release 1 (12.1)

Transactions

In-Doubt Transactionsof in-doubt distributed transactions. After the failure is repaired and communication is … distributed transactions consistently on all involved nodes. In the event of a long-term failure … transactions that are in doubt because of the failure. This option enables the local database administrator to … Administrator's Guide to

Database Concepts, 12c Release 1 (12.1)

Transactions

Introduction to Transactionsassigns every transaction a unique identifier called a transaction ID. All Oracle transactions obey the … transactions. For example, if a transaction starts updating 100 rows, but the system fails after 20 … transaction is not visible to other transactions until the transaction is committed. For example … concurrently by another

Database Concepts, 12c Release 1 (12.1)

Transactions

Statement-Level AtomicityOracle Database supports statement-level atomicity, which means that a SQL statement is an atomic unit of work and either completely succeeds or completely fails. A successful statement is different from a committed transaction. A single SQL statement executes successfully if the database parses and runs it without error as an atomic unit, as when all rows are changed in a multirow update. If a SQL

Database Concepts, 12c Release 1 (12.1)

Transactions

System Change Numbers (SCNs)A system change number (SCN) is a logical, internal time stamp used by Oracle Database. SCNs order events that occur within the database, which is necessary to satisfy the ACID properties of a transaction. Oracle Database uses SCNs to mark the SCN before which all changes are known to be on disk so that recovery avoids applying unnecessary redo. The database also uses SCNs to mark the point at which

Database Concepts, 12c Release 1 (12.1)

Transactions

Transaction Namesadvantages: It is easier to monitor long-running transactions and to resolve in-doubt distributed … transactions. You can view transaction names along with transaction IDs in applications. For example, a

Database Concepts, 12c Release 1 (12.1)

Transactions

Table 10-2 Rollback to Savepoint ExampleEnqueued Transactions Depending on the scenario, transactions waiting for previously locked

Database Concepts, 12c Release 1 (12.1)

Transactions

Overview of Transaction Guardguarantee that it would not commit after being checked, permitting duplicate transactions and other … online and be charged twice for the same book. See Also: \" Introduction to Transactions \" Oracle

Database Concepts, 12c Release 1 (12.1)

Transactions

How Transaction Guard WorksThis section explains the problem of lost commit messages and how Transaction Guard uses logical transaction IDs to solve the problem.

Database Concepts, 12c Release 1 (12.1)

Transactions

Transaction Guard: Examplesession that failed. For each round trip from the client in which one or more transactions are committed … , the application can replay transactions when the error is recoverable and the last transaction on

Database Concepts, 12c Release 1 (12.1)

Transactions

Overview of Application ContinuityApplication Continuity attempts to mask outages from applications by replaying incomplete application requests after unplanned and planned outages. In this context, a request is a unit of work from the application. Typically, a request corresponds to the DML statements and other database calls of a single web request on a single database connection. In general, a request is demarcated by the calls