首页 » ORACLE 9i-23c » types of undo segments(undo段类型)

types of undo segments(undo段类型)

从9i开始系统已经用undo替换掉了以前版本中的rollback,两种名称的意义是相同的,虽然现在改成了undo 不过,在数据字典查询中依然是去dba_rollback_segs中去查询;

有三种类型
 
     1,system 回滚段,   它是系统本身自己用的回滚段,保留在system tablespace 表空间中

    2,non-system回滚段   非系统的回滚段同时又分为两种情况
                         a) auto mode     是保留在系统参数中指定的 UNDO tablespace表空间中。
                         b) manul mode  又分为两类
                                          — private    single instance
                                          — public    RAC any instance

    3,deferrd    与system 回滚段一样也不需要人为的干涉,用于在把tablespace offline 到非normal,及immediate、temproray、for recovery时,再把tablespace online时
 做介质恢复里使用,因为这三种情况并没有把所有数据文件checkpoint;

与undo 设置相关的参数

undo_managment =  auto|manul
自动管理还时手动管理
undo_tablespace = xxx
当配置为自动管理时,有且只能激活一个UNDO TABLESPACE;
undo_supperess_errors = true|false    ———9i中的参数,在10已不存在
当在自动管理的mode下,手动建立rollback segment时,是否忽略这个错误操作
undo_retention
配置即使当你commit后,undo会保留的时间,用于回闪

打赏

目前这篇文章有12条评论(Rss)评论关闭。

  1. Deadra Carranzo | #1
    2011-12-21 at 04:45

    I simply wanted to thank you so much all over again. I am not sure what I would’ve followed without the entire pointers provided by you concerning that question. It was actually the fearsome situation for me personally, however , taking note of a new expert mode you solved that took me to leap with gladness. I’m happy for this guidance and even trust you recognize what a great job you’re undertaking educating people today through the use of your web blog. Most probably you haven’t encountered all of us.

  2. Johanne Cuadro | #2
    2011-12-17 at 19:13

    Appreciating the time and effort you put into your site and detailed information you present. It’s nice to come across a blog every once in a while that isn’t the same out of date rehashed information. Fantastic read! I’ve saved your site and I’m adding your RSS feeds to my Google account.

  3. Replica Louis Vuitton | #3
    2011-09-30 at 19:21

    Excellent beat ! I wish to apprentice even as you amend your website, how can i subscribe for a blog website? The account aided me a applicable deal. I were a little bit acquainted of this your broadcast provided shiny transparent idea

  4. Illiana Mccall | #4
    2011-09-19 at 22:21

    In your article I found very different things. Very characteristic. I鈥檝e never seen before.Thank you very much the share. you are very creative.

  5. August Sutton | #5
    2011-09-19 at 19:47

    Awesome blog! I just added it to my bookmarks!