Undo Mode (30)
Undo mode provides a more flexible way to migrate from manual undo management
to automatic undo management. A database system can run in either manual undo
management mode or automatic undo management mode. In manual undo
management mode, undo space is managed through rollback segments. In automatic
undo management mode, undo space is managed in undo tablespaces. To use
automatic undo management mode, the database administrator needs only to create
an undo tablespace for each instance and set the UNDO_MANAGEMENT initialization
parameter to AUTO. You are strongly encouraged to run in automatic undo
management mode.
使用AUM:
1. 建立undo tablespace
2. UNDO_MANAGEMENT設定為AUTO
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/10599713/viewspace-969422/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 使用_smu_debug_mode瞭解undo tablespace
- Open a Database in Read-Only Mode (301)Database
- ORA-30046: Undo tablespace UNDOTBS1 not found in control file 無undo啟動庫
- 奇怪的OGG問題:DBLOGREADER mode: (308) ORA-00308
- [20130312]undo與DML-delete.txtdelete
- [20130904]等待事件wait for a undo record.txt事件AI
- [20130904]等待事件wait for a undo record模擬.txt事件AI
- Window mode
- consistent mode和current mode的區別
- ORA-30012 undo tablespace 'UNDOTBS3' does not exist or of wrong typeS3
- Oracle - ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDOTBS1'Oracle
- [20130808]12c新特性Temporary undo.txt
- Innodb undo之 undo結構簡析
- MySQL undoMySql
- Docker Swarm modeDockerSwarm
- oracle time modeOracle
- javascript strict modeJavaScript
- TM LOCK MODE
- sql_modeSQL
- Windws XP Mode
- Dataguard mode switch
- 更改Archive ModeHive
- error X3025:global variables are implicitly constant, enable compatibility mode to allow modificationError
- ftp命令 binary mode與ascii mode的區別FTPASCII
- 2 萬字 + 30 張圖 | 細聊 MySQL undo log、redo log、binlog 有什麼用?MySql
- Oracle Redo and UndoOracle Redo
- Oracle undo 管理Oracle
- Git undo 操作Git
- mysql undo管理MySql
- Oracle Undo SegmentOracle
- oracle undo管理Oracle
- oracle undo一Oracle
- 【UNDO】使用重建UNDO表空間方法解決UNDO表空間過大問題
- Innodb undo之 undo物理結構的初始化
- MySQL Strict SQL MODEMySql
- IDBTransaction.mode
- UFS之Power Mode
- chmod命令(change mode)