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博客 ” ，链接：https://blog.itpub.net/10599713/viewspace-995748/ ，如需转载，请注明出处，否则将追究法律责任。
-
博文量740
-
访问量2002850
最新文章
- 人力&人手&人才&人物
- oracle树中prior的用法
- Using Supplied Packages to Manage Stored Outlines
- $ORACLE_HOMERDBMSADMIN目录下各SQL的含义
- PRODUCT_USER_PROFILE Table
- Backing Up Server Parameter Files with RMAN
- Backing Up Control Files with RMAN
- Backing Up Individual Tablespaces with RMAN
- Making Whole Database Backups with RMAN
- 目睹奥运火炬传递
