引數FAST_START_PARALLEL_ROLLBACK

zwunixdb發表於2013-11-01
Property Description
Parameter type String
Syntax FAST_START_PARALLEL_ROLLBACK = { HI | LO | FALSE }
Default value LOW
Modifiable ALTER SYSTEM
Basic No

FAST_START_PARALLEL_ROLLBACK determines the maximum number of processes that can exist for performing parallel rollback. This parameter is useful on systems in which some or all of the transactions are long running.

Values:

  • FALSE indicates that parallel rollback is disabled

  • LOW limits the number of rollback processes to 2 * CPU_COUNT

  • HIGH limits the number of rollback processes to 4 * CPU_COUNT

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

相關文章