Performance Considerations of FORCE LOGGING Mode (84)

tsinglee發表於2007-12-25

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. 該模式會造成效能的下降

[@more@]

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/10599713/viewspace-995748/,如需轉載,請註明出處,否則將追究法律責任。

相關文章