0 Replies Latest reply: Jul 5, 2012 10:10 PM by 947753 RSS

    Queue Monitor Processes

    947753
      My Oracle server is 9.2.0.6 Batch Set. I faced a runtime error related to Queue Monitor Processes. Restarting dead background processQMN0, an error message, was displayed after running startup mount; during a backup process. A few web sites explain the cause that the SGA initialization could not be be finished within 30s. Many web sites advise to run alter system set aq_tm_process=0 scope=both; but the Significance of AQ_TM_PROCESSES Parameter section of https://blogs.oracle.com/db/entry/oracle_support_master_note_for_aq_queue_monitor_process_qmon_doc_id_3056621 opposes this approach. How can I avoid this error?

      Edited by: 944750 on Jul 5, 2012 8:09 PM