Oracle Database - UNDO (Rollback Segment)

Card Puncher Data Processing

What is UNDO ?

rollback journal in Oracle.

Support

ORA-01555 - snapshot too old

ORA-01555: snapshot too old: rollback segment number 12 with name "_SYSSMU12_253434260$" too small '

  • The UNDO space was too small. The SELECT statement was killed letting the DML operations continue.
  • Of the Minimum Undo Retention Period was achieved Minimum Undo Retention

See AskTom

Reference/Documentation





Discover More
Card Puncher Data Processing
Oracle Database - Consistent (Read get|Buffer Mode) (CR)

A consistent read get is a retrieval of a read-consistent version of a block from the buffer_cache and then may include read asides to UNDO (rollback segments). A query will generally perform “consistent...
Card Puncher Data Processing
Oracle Database - Direct (path insert|load) (/*+ APPEND */)

A direct-path insert is also known as: direct load A direct-path insert is a bulk operation which will only bypass redo log generation in three cases : the database is in NOARCHIVELOG mode database...
Card Puncher Data Processing
Oracle Database - Distributed Transactions

A 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...
Card Puncher Data Processing
Oracle Database - How to bypass the redo log generation ?

A direct path insert will only bypass Redo Log generation in two cases : the database is in NOARCHIVELOG Mode the operation is performed on a table marked as NOLOGGING The insert /+ APPEND / will...
Card Puncher Data Processing
Oracle Database - Internal Locks

Internal locks are higher-level, more complex mechanisms than latches and mutexes and serve various purposes. The database uses the following types of internal locks: These locks are of very short...
Toad Lock
Oracle Database - Locks

Lock Mechanism in Oracle Oracle Database provides: data concurrency, consistency. The data a session is viewing or changing must not be changed by other sessions until the user is finished. and...
Card Puncher Data Processing
Oracle Database - Partition Exchange for Data Movement / Data Load

One of the most challenging aspects of data warehouse administration is the development of ETL (extract, transform, and load) processes that load data from OLTP systems into data warehouse databases. ...
Card Puncher Data Processing
Oracle Database - ROLLBACK (undo of a transaction)

Use the ROLLBACK statement to undo work done in the current transaction or to manually undo the work done by an in-doubt distributed transaction. An implicit ROLLBACK occurs when the session (or...
Card Puncher Data Processing
Oracle Database - SAVEPOINT (of a transaction)

A savepoint is a user-declared intermediate marker within the context of a transaction. Internally, this marker resolves to an SCN. Savepoints divide a long transaction into smaller parts. If you use...
Card Puncher Data Processing
Oracle Database - System Change Numbers (SCNs) - Point in time

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



Share this page:
Follow us:
Task Runner