Search This Blog

Friday, April 24, 2009

WARNING: AQ_TM_PROCESSES is set to 0. System operation might be adversely affected

Dear Friends,

If your getting below "Warning" message frequently in the alert.log file...

"WARNING: AQ_TM_PROCESSES is set to 0. System operation might be adversely affected."

Kindly check the following metalink note: 428441.1

Solution: The parameter "AQ_TM_PROCESSES" should not be set "0" or "Unset". Set it atlest for "1".

It is dynamic parameter so no need to bounce the db server.

SQL>alter system set AQ_TM_PROCESSES=1;


4 comments:

Anonymous said...

Good dispatch and this enter helped me alot in my college assignement. Thank you as your information.

Anonymous said...

Approvingly your article helped me terribly much in my college assignment. Hats high to you enter, intention look forward in behalf of more interdependent articles in a jiffy as its one of my favourite topic to read.

Anonymous said...

I think you will want to get a facebook button to your site. Just bookmarked this article, although I had to do it by hand. Simply my suggestion.

ora-code said...

The parameter can be unset from 10g.