`

(10) Managing Undo Data

SQL 
阅读更多
  • show parameter undo;
  • SQL> alter tablespace xxx offline (immediate,temporary or for recovery)

    SQL>recover datafile 'xxx'

    SQL> show parameter undo
  • NAME                                 TYPE                   VALUE
    ------------------------------------ ---------------------- ---------
    undo_management                      string                 AUTO(manual)
    undo_retention                       integer                10800
    undo_suppress_errors                 boolean                FALSE
    undo_tablespace                      string                 UNDOTBS1

    SQL> select * from dba_rollback_segs;

    SQL> drop tablespace xxx  (先切换,并且老的里面transaction已经都提交了)

    SQL> create rollback segment rbs1 tablespace undotbs; (手工创建回滚段)

    SQL> execute dbms_flashback.enable_at_time()

    SQL> execute dbms_flashback.disable

    Undo Data Statistics

    SQL> select end_time,begin_time,undoblks from v$undostat;

     

    UndoSpace = [UR(s) * (UPS * DBS)] + (DBS*24)

    UR: UNDO_RETENTION

    UPS: Number of undo data blocks generated per second

    DBS: db_block_size

     

    UNDO Quota for users

    UNDO_POOL

     

    DBA_ROLLBACK_SEGS

    v$ROLLNAME  v$ROLLSTAT  v$UNDOSTAT  v$SESSION  v$TRANSACTION

     

    手工管理回滚段

    SQL> show parameter transactions

  • NAME                                 TYPE                   VALUE
    ------------------------------------ ---------------------- ------
    transactions                         integer                187
    transactions_per_rollback_segment    integer                5

    SQL> show parameter rollback

  • NAME                                 TYPE                   VALUE
    ------------------------------------ ---------------------- ------
    fast_start_parallel_rollback         string                 LOW
    max_rollback_segments                integer                37
    rollback_segments                    string                 ('rbs1','rbs2',...)
    transactions_per_rollback_segment    integer                5

    SQL> create (public) rollback segment prbs1 tablespace undotbs;

    SQL> alter rollback segment rbs1 online;

     

分享到:
评论
发表评论

文章已被作者锁定,不允许评论。

相关推荐

    Oracle_Database11g-Administration_Workshop2-2-1212.pdf

    10 Managing Undo Data 11 Implementing Oracle Database Auditing 12 Database Maintenance 13 Performance Management 14 Backup and Recovery Concepts 15 Performing Database Backups 16 Performing ...

    Oracle_Database11g-Administration_Workshop_I-2-1212.pdf

    10 Managing Undo Data 11 Implementing Oracle Database Auditing 12 Database Maintenance 13 Performance Management 14 Backup and Recovery Concepts 15 Performing Database Backups 16 Performing ...

    Oracle_Database11g-Administration_Workshop2-1-1212.pdf

    10 Managing Undo Data 11 Implementing Oracle Database Auditing 12 Database Maintenance 13 Performance Management 14 Backup and Recovery Concepts 15 Performing Database Backups 16 Performing ...

    Oracle_Database11g-Administration_Workshop2-3-1212.pdf

    10 Managing Undo Data 11 Implementing Oracle Database Auditing 12 Database Maintenance 13 Performance Management 14 Backup and Recovery Concepts 15 Performing Database Backups 16 Performing ...

    Oracle_Database11g-Administration_Workshop_I-1-1212.pdf

    10 Managing Undo Data 11 Implementing Oracle Database Auditing 12 Database Maintenance 13 Performance Management 14 Backup and Recovery Concepts 15 Performing Database Backups 16 Performing ...

    Oracle11gOCP--1Z0-052视频集锦

    教程名称:Oracle 11g OCP--1Z0-052 视频集锦课程目录:【】1-Course Introduction【】10-Managing Data and Concurrency【】11-Managing Undo Data【】12-Implementing Oracle Database Security【】13-Database M ...

    oracle培训讲义2002

    英文版pdf 1Oracle Architectural Components 2Managing an Oracle Instance 3Creating a Database 4Managing an Oracle Database 5Managing Undo Data 6Managing Tables, Indexes and Integrity...

    oracle 10g-admin1 考试试题

    ### Oracle 10g Administration I (1Z0-042) Exam Knowledge Points #### 1. Determining the Size of the Undo Tablespace When deciding on the size of the undo tablespace in your Oracle database, three ...

    MP3 Book Helper

    Undo and preview for all changes, capitalization, search and replace, use parts of file name or directory structure for tags. Directory renaming and restructure based on tags. All customizable and ...

    Linux Kernel 2.4 Internals

    This section discusses the data structures used to implement semaphores, including `struct sem_array`, `struct sem`, `struct seminfo`, `struct semid64_ds`, `struct sem_queue`, `struct sembuf`, and `...

    Visual C++ 编程资源大全(英文源码 其它)

    37.zip Microsecond delay 百万分子一的延时(4KB)<END><br>38,38.zip Messagebox with printf capability 有printf能力的Messagebox(4KB)<END><br>39,39.zip Multiple Level Undo/Redo 多级Undo/...

    opensc-0.12.0.tar.gz

    * undo user_content changes to retain compatibility with 0.9.4. * add solaris/ files for easier installation on solaris. * Makefile.am: require automake 1.5 * free() fixes in some card drivers. * fix ...

    ANSYS SpaceClaim 2016 User Guide

    - **Creating, Opening, and Saving Documents**: Covers the basics of managing files, including saving work in progress and opening existing projects. - **Importing and Exporting**: Supports a wide ...

    最完整的Toad For Oracle使用手册

    - **Managing Projects**:涵盖了项目管理的各种方法。 - **Using Automation Designer to Control Toad**:介绍了如何使用自动化设计器来控制Toad。 - **Project Manager**:提供了项目管理器的使用方法。 #### 十...

    Visual C++ 编程资源大全(英文源码 表单)

    (16KB)<END><br>87,undo.zip Easily add Undo/Redo to your CDocument/CView Based Applciation(2KB)<END><br>88,PropertyView.zip A "Property Sheet"-like view class for MFC (108KB)<END><br>89,...

Global site tag (gtag.js) - Google Analytics