Performance Considerations of FORCE LOGGING Mode (84)
FORCE LOGGING mode results in some performance degradation. If the primary
reason for specifying FORCE LOGGING is to ensure complete media recovery, and
there is no standby database active, then consider the following:
■ How many media failures are likely to happen?
■ How serious is the damage if unlogged direct writes cannot be recovered?
■ Is the performance degradation caused by forced logging tolerable?
If the database is running in NOARCHIVELOG mode, then generally there is no benefit
to placing the database in FORCE LOGGING mode. Media recovery is not possible in
NOARCHIVELOG mode, so if you combine it with FORCE LOGGING, the result may be
performance degradation with little benefit.
FORCE LOGGING模式下的效能考慮
1. 該模式會造成效能的下降
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/10599713/viewspace-995748/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Specifying FORCE LOGGING Mode (82)
- Performance and Storage Considerations (217)ORMIDE
- 2.5.11 指定 FORCE LOGGING 模式模式
- 日誌記錄模式(LOGGING 、FORCE LOGGING 、NOLOGGING)模式
- 425alter database force logging修改那裡Database
- NOLOGGING和FORCE LOGGING的理解
- nologging、force logging、supplemental log的理解
- create index logging, nologging performance testIndexORM
- 2.5.11.2 FORCE LOGGING 模式需要考慮的效能問題模式
- 實驗說明為什麼DataGuard需要設定force logging
- IBM POWER7 AIX and Oracle Database performance considerations-10g&11g_1507249.1IBMAIOracleDatabaseORMIDE
- IBM POWER7 AIX and Oracle Database performance considerations--10g&11g_1507249.1IBMAIOracleDatabaseORMIDE
- 11g append 和常規insert在logging FORCE_LOGGING產生redo量差異APP
- Oracle資料庫中NOLOGGING和FORCE LOGGING的理解Oracle資料庫
- 案例:DG主庫未設定force logging導致備庫壞塊
- House Of Force
- SAP KANBAN and Implementation ConsiderationsIDE
- Data Warehousing Considerations (245)IDE
- DG主庫忘記force logging情況下,insert append了nologgin表操作APP
- STARTUP FORCE 理解
- SpringCloud-84SpringGCCloud
- Oracle OCP 1Z0 053 Q517(Block Media Recovery&Archivelog Mode&Flashback Logging)OracleBloCHive
- performance of the databaseORMDatabase
- Window mode
- rman backup database force 功能Database
- consistent mode和current mode的區別
- MySQL Performance SchemaMySqlORM
- Website Performance OptimizationWebORM
- Oracle Performance ChecklistOracleORM
- SQL Performance AnalyzerSQLORM
- to improve sqlite performanceSQLiteORM
- 《HelloGitHub》第 84 期Github
- go - LoggingGo
- innodb_force_recovery設定
- Docker Swarm modeDockerSwarm
- oracle time modeOracle
- javascript strict modeJavaScript
- TM LOCK MODE