Oracle UNDO management tips

简介:

Oracle UNDO management tips

Oracle Tips by Burleson Consulting

May 4, 2010



Question:   What are some tips for managing Oracle UNDO?

Answer:   Here are my notes on

general undo management

 and

Undo Management in RAC

,

Here are other undo management notes:
  1. Change Oracle undo mode from automatic to manual

  2. Initialization Parameters for UNDO management

    Oracle automatic undo retention management

  1. Undo Retention Tuning

  2. UNDO Management secrets

    Oracle automatic UNDO management tips

本文转自海天一鸥博客园博客,原文链接:http://www.cnblogs.com/sgsoft/archive/2010/12/15/1907361.html,如需转载请自行联系原作者
相关文章
|
SQL Oracle 关系型数据库
Oracle 短时间内误删数据,如何快速找回?(UNDO)
首先,这个短时间内,通常是值 undo 段没有被覆盖,undo 保留的时间为多长呢? 1、需要看 undo_retention 的设置,默认为 900s,也就是 15 分钟。 2、需要看数据库的业务繁忙程度,如果1天切一个归档那种,3天前删的说不定都能用 UNDO 找回来。
|
Oracle 关系型数据库 数据库
|
SQL Oracle 关系型数据库
|
Oracle 关系型数据库 数据库