Results for ROLLBACK


1 to 20 of 1549 results. Prev  Next
Results per page:   20  | 40 | 60


SQL Reference, 9i Release 2 (9.2.0.2)

SQL Statements: DROP SEQUENCE to ROLLBACK, 19 of 19

ROLLBACKPurpose Use the ROLLBACK statement to undo work done in the current transaction, or to manually … end transactions in application programs using either a COMMIT or ROLLBACK statement. If you do not

Oracle® C++ Call Interface Programmer's Guide, 9i Release 2 (9.2.0.2)

OCCI Classes and Methods, 6 of 22

rollback()This method drops all changes made since the previous commit or rollback, and releases any database … locks currently held by the session. Syntax void rollback();

Supplied Java Packages Reference, 9i Release 2 (9.2.0.2)

Package oracle.jms

rollback()public synchronized void rollback() Rollback any messages done in this transaction and releases any … Throws JMSException - if JMS implementation fails to rollback the the transaction due to some internal error.

Objects for OLE, 9i Release 2 (9.2.0.2)

Rollback Method

Rollback MethodFeedback Rollback Method See Also Example Applies To OraConnection OraDatabase OraSession Description … .Rollback orasession.Rollback oradatabase.Rollback Remarks When this method is invoked, all … rollback request. If they do not cancel the request, they are then advised when the rollback

Objects for OLE, 9i Release 2 (9.2.0.2)

Rollback Method

Rollback MethodMaster Index Feedback Rollback Method Applies To OSession Description This method rolls back the … current transaction. Usage oresult Rollback (oboolean startnew = FALSE) Arguments startnew If TRUE a … a Rollback. It is an error to call Rollback when no transaction is in progress. Calling Rollback

Event Test Reference Manual, 9i Release 2 (9.2.0.2)

Oracle Database Event Tests

Rollback ContentionDescription Rollback segments are portions of the database that record the actions of transactions … in case a transaction is rolled back. Rollback segments are used to provide read consistency … , support rollback transactions, and recover a database. Proper allocation of rollback segments make for … optimal

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

DBMS_TRANSACTION, 2 of 2

ROLLBACK ProcedureThis procedure is equivalent to following SQL statement: ROLLBACK Here for completeness. This is already implemented as part of PL/SQL.

User's Guide and Reference, 9i Release 2 (9.2.0.2)

PL/SQL Language Elements, 42 of 52

ROLLBACK StatementThe ROLLBACK statement is the inverse of the COMMIT statement. It undoes some or all database

Objects for OLE, 9i Release 2 (9.2.0.2)

Rollback Method Example

Rollback Method ExampleFeedback Rollback Method Example This example demonstrates the use of BeginTrans and Rollback to group a

Objects for OLE, 9i Release 2 (9.2.0.2)

Rollback (ODatabase) Method

Rollback (ODatabase) MethodMaster Index Feedback Rollback (ODatabase) Method Applies To ODatabase Description Ends the current … transaction and rolls back all pending changes to the database. Usage oresult Rollback (void) const … session or connection are given the opportunity to cancel the rollback request. If they do not cancel … the request, they are

Concepts, 9i Release 2 (9.2.0.2)

Transaction Management

Rollback of Transactionsuncommitted transaction. Oracle uses undo tablespaces or rollback segments to store old values. The … called a savepoint. All types of rollbacks use the same procedures: Statement-level rollback (due to … statement or deadlock execution error) Rollback to a savepoint Rollback of a transaction due to user … request

Performance Tuning Guide and Reference, 9i Release 2 (9.2.0.2)

Configuring Undo and Temporary Segments

Configuring Rollback SegmentsAutomatic undo management is the preferred way of handling rollback space. Automatic undo … set of statically allocated rollback segments. The creation and allocation of space among the undo … segments is handled automatically by the Oracle server. With rollback segments, one or more … tablespaces are created; rollback

Administrator's Guide, 9i Release 2 (9.2.0.2)

Managing Undo Space

Managing Rollback SegmentsIf you choose to use rollback segments to store undo, the following sections guide you in their … management: Guidelines for Managing Rollback Segments Creating Rollback Segments Altering Rollback … Segments Explicitly Assigning a Transaction to a Rollback Segment Dropping Rollback Segments

SNMP Support Reference Guide, 9i Release 2 (9.2.0.2)

Designing Management Applications Based on Oracle MIBs

User Rollback RatiooraDbSysUserRollbacks / (oraDbSysUserCommits + oraDbSysUserRollbacks) is the user rollback ratio … . The user rollback ratio indicates the rate at which application transactions are failing. Rolling

Precompilers, 9i Release 2 (9.2.0.2)

Embedded SQL Commands and Directives

ROLLBACK (Executable Embedded SQL)Purpose To undo work done in the current transaction.

Pro*C/C++ Programmer's Guide, 9i Release 2 (9.2.0.2)

Embedded SQL Statements and Directives

ROLLBACK (Executable Embedded SQL)transaction to the specified savepoint. If you omit this clause, the ROLLBACK statement rolls back … transactions, query the data dictionary view DBA_2PC_PENDING. ROLLBACK statements with the FORCE … statement after a COMMIT, ROLLBACK or connection to the database. A transaction ends with a COMMIT … statement, a ROLLBACK

Pro*COBOL® Programmer's Guide, 9i Release 2 (9.2.0.2)

Database Concepts

Using the ROLLBACK StatementYou use the ROLLBACK statement to undo pending changes made to the database. For example, if you … make a mistake, such as deleting the wrong row from a table, you can use ROLLBACK to restore the … original data. The ROLLBACK statement has no effect on the values of host variables or on the flow of … control in your program. Specifically,

SQL Reference, 9i Release 2 (9.2.0.2)

SQL Statements: CREATE TYPE to DROP ROLLBACK SEGMENT, 26 of 26

DROP ROLLBACK SEGMENTPurpose Use the DROP ROLLBACK SEGMENT to remove a rollback segment from the database. When you drop … a rollback segment, all space allocated to the rollback segment returns to the tablespace. Note: If … rollback segments. In that mode, you cannot create or alter a rollback segment.

Administrator's Guide, 9i Release 2 (9.2.0.2)

Managing Undo Space

Dropping Rollback SegmentsYou can drop rollback segments when the extents of a segment become too fragmented on disk, or the … segment needs to be relocated in a different tablespace. Before dropping a rollback segment, make … sure that the status of the rollback segment is OFFLINE. If the rollback segment that you want to drop … dropped.

Administrator's Guide, 9i Release 2 (9.2.0.2)

Managing Undo Space

Viewing Rollback Segment InformationThis section presents views that can be used to obtain and monitor rollback segment information … : Rollback Segment Views Displaying Rollback Segment Information Monitoring Rollback Segment Statistics … Displaying All Rollback Segments Displaying Whether a Rollback Segment Has Gone





Was this page helpful?

Integrated Cloud Applications & Platform Services