Month: December 2009

Notes on ‘Expert Oracle’ — No.9.6: Redo&Undo — Undo Log

1. Amount of Undo Log     Delete > Update > Insert     Operations on Indexed Columns > Operations on Non-indexed 2. What can cause "Snap Too Old"  exception?  => The undo segment is too small 3. How to make the undo segment not so small?    a. Enlarge it, of course       i.Enlarge UNDO_RETENTION, which …

Notes on ‘Expert Oracle’ — No.9.6: Redo&Undo — Undo Log Read More »

Notes on ‘Expert Oracle’ — No.9.5: Redo&Undo — Block Cleanout

a.When data blocks are involved in a transaction, there are locking info created in the block. b.This info should be cleaned out when the transaction ends. c.They can be cleaned out immediately when the transaction ends, but not definitely.    —- There are cleaned out on commitment, only if the blocks needed to be cleaned …

Notes on ‘Expert Oracle’ — No.9.5: Redo&Undo — Block Cleanout Read More »

Notes on ‘Expert Oracle’ — No.9.4: Redo&Undo — More about Redo Log

1. The large your Redo log is, the more time-consuming your SQL operation is. 2. Can we turn off Redo Log?    a. Not Recommeded    b. You can use "NOLOGGING" in SQLs to reduce much of the log.    c. You can also use "NOLOGGING" for INDEX. This is actually acceptable. 3. How to …

Notes on ‘Expert Oracle’ — No.9.4: Redo&Undo — More about Redo Log Read More »