Tuesday, October 2, 2007

"SMON: Parallel transaction recovery tried"


Wed Sep 26 11:34:23 2007
SMON: Parallel transaction recovery tried

We found above message in alert_sid.log file.


No need to worry about it. it is information message ...SMON start recovery in parrallel but failed and done in serial mode.
at

2 comments:

  1. AnonymousThu Sep 25, 01:46:00 AM

    fast_start_paralell_rollback default is slow, ¿recommend change to high?

    ReplyDelete
  2. halimdbaMon Jul 11, 03:30:00 PM

    also consider when need to change
    parallel_max_servers parameter .

    In my system, I changed the
    "parallel_max_servers" parameter from 2560 to 300 . after that i am finding this message .

    because, SMON failed to generate the slave servers(what are define at this "FAST_START_PARALLEL_ROLLBACK" parameter ) necessary to perform a parallel rollback of a transaction

    may be its value is HIGH or LOW value is greater then parallel_max_servers parameter .

    ReplyDelete