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
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 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 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
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 Names → A 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
Transaction Management → Oracle Database is designed as a multiuser database. The database must ensure that multiple users can work concurrently without corrupting one another's data.
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 → 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 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
Transaction Control Statements → not 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
Overview of Transaction Control → Transaction 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
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.
Structure of a Transaction → Figure 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
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
Oracle Transaction Management → Part III Oracle Transaction Management This part contains the following chapters: Chapter 10
Autonomous Transactions → An 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