Undo Space Acquisition and Management (299)
When you open the database, the instance attempts to acquire one or more undo
tablespaces. You determine whether to operate in automatic undo management mode
or manual undo management mode at instance startup using the UNDO_MANAGEMENT
initialization parameter. The supported values are AUTO or MANUAL. If AUTO, then the
instance is started in automatic undo management mode. The default value is MANUAL.
■ If you use the undo tablespace method, then you are using automatic undo
management mode. This is recommended.
■ If you use the rollback segment method of managing undo space, then you are
using manual undo management mode.
回滾表空間的獲取和管理
1. 當開啟資料庫時 , 例項需要獲取一個或多個回滾表空間
2. 如果使用者正使用撤銷表空間 , 那麼資料庫就執行在自動撤銷管理模式下 . Oracle 建議採用此種模式.
3. 如果使用者正使用回滾段管理撤銷空間,那麼資料庫就執行在手工撤銷管理模式下 .
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/10599713/viewspace-987419/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 2.6.8.1 UNDO_MANAGEMENT 初始化引數
- ocp 19c考題,科目082考試題(23)- space management within blocks managed ASSMBloCSSM
- [題解]AT_abc299_f [ABC299F] Square Subsequence
- Leetcode 299 Bulls and CowsLeetCode
- Exercise 5: Field data acquisition and analysisUI
- Halcon採集影像Image Acquisition解析UI
- 28、undo_1_2(undo引數、undo段、事務)
- Customer Management
- 聊聊dba_temp_free_space的allocated_space和free_space
- Innodb undo之 undo結構簡析
- Hilbert Space
- MySQL undoMySql
- Memory Management in RustRust
- Oracle Redo and UndoOracle Redo
- Innodb undo之 undo物理結構的初始化
- 2.5.5 使用自動Undo管理: 建立 Undo 表空間
- Oracle Cluster Time ManagementOracle
- ASM(Automatic Storage Management)ASM
- show_space(轉)
- CSS white-spaceCSS
- D. Explorer Space
- 切換UNDO(zt)
- InnoDB undo log原理
- MySQL purge 清理undoMySql
- LeetCode 299 猜數字遊戲 Java實現LeetCode遊戲Java
- JMX-Java Management ExtensionsJava
- Automatic Storage Management (ASM)(轉)ASM
- Oracle Shared Pool Memory ManagementOracle
- SQL Server Management Studio (SSMS)SQLServerSSM
- dx12 memory management
- ACFIM0019 Financial ManagementNaN
- Stability Study with SAP Quality Management
- Physical Samples Management in SAP QM
- User Exits for WM (Warehouse Management)
- Oracle 12c 新特性之臨時Undo--temp_undo_enabledOracle
- undo表空間容量
- undo log和redo log
- 4.2.1.9 選擇 Undo 模式模式
- oracle undo分配規則Oracle