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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- oracle segment space management and extent management幾則Oracle
- Oracle-Segment space managementOracle
- UNDO_MANAGEMENT Initialization Parameter (118)
- Run Out Of Space On UNDO Tablespace Using DataPump Import/ExportImportExport
- 【paramter】undo_management設定為auto與manaul的區別
- Happiness, an acquisition listAPPUI
- Oracle OCP 1Z0-053 Q635(FRA Space Management)Oracle
- [zt] dmt、lmt、mssm, assm (SEGMENT SPACE MANAGEMENT AUTO) 的一點總結SSM
- Oracle10g New Feature --12. ASSM ( Automatic Segment Space Management )OracleSSM
- Exercise 5: Field data acquisition and analysisUI
- ocp 19c考題,科目082考試題(23)- space management within blocks managed ASSMBloCSSM
- Halcon採集影像Image Acquisition解析UI
- [題解]AT_abc299_f [ABC299F] Square Subsequence
- 【併購之我見】Oracle's acquisition of SunOracleUI
- Hilbert Space
- Leetcode 299 Bulls and CowsLeetCode
- Memory Management in RustRust
- PostgreSQL Role ManagementSQL
- SQL management baseSQL
- Credit Management(SD)
- SQL Plan ManagementSQL
- Innodb undo之 undo結構簡析
- MySQL undoMySql
- No space left on devicedev
- Tablespace Space Script
- Oracle Cluster Time ManagementOracle
- memory management unit (MMU)
- Linux Memory ManagementLinux
- SQL Plan Management(SPM)SQL
- dispute management and new ES
- Management on database linkDatabase
- Management of Remote Dependencies (252)REM
- Master Data Management UpdateAST
- Management of Materials With Shelf Life
- show_space.sqlSQL
- Oracle DBMS_SPACEOracle
- space.itpub印象
- Oracle Redo and UndoOracle Redo