Using manual transactions

Allocation of a Rollback Segment When a transaction begins, a rollback segment must be assigned to this transaction. A transaction can request a specific rollback segment using the following command: SET TRANSACTION USE ROLLBACK SEGMENT rollback_segment If no such request is made, the Oracle server chooses the rollback segment with the fewest transactions and assigns it to the transaction. Using Extents Transactions use extents of a rollback segment in a sequential, circular fashion, moving from one to the next after the current extent is full.

22p trinh02 28-01-2013 69 5   Download

Incomplete Recovery Incomplete recovery reconstructs the database to a prior point in time (before the time of the failure). Note: This situation results in the loss of data from transactions committed after the time of recovery. This data will need to be reentered manually if required. Perform this recovery only when absolutely necessary. Incomplete recovery can be a difficult and time-consuming operation.

28p trinh02 28-01-2013 45 5   Download

[ Team LiB ] Recipe 6.3 Nesting Manual Transactions with the SQL Server .NET Data Provider Problem You need to create a nested transaction using the SQL Server .NET data provider, but the Begin( ) command that you need is only available with the OLE DB .NET data provider.

4p luvpro 04-08-2010 117 9   Download

[ Team LiB ] Recipe 6.2 Using Manual Transactions Problem You need to explicitly begin, control, and end a transaction within a .NET application. Solution Use the Connection object with structured exceptions (try . . . catch . . . finally).

4p luvpro 04-08-2010 87 9   Download