WARNING: AQ_TM_PROCESSES is set to 0. System operation might be adversely affected.
If you get WARNING while starting up your database:
WARNING: AQ_TM_PROCESSES is set to 0. System operation might be adversely affected.
You can do these steps based on Metalink Document: 428441.1
SQL> connect / as sysdba
SQL> alter system reset aq_tm_processes scope=spfile sid='*';
SQL> shutdown immediate;
SQL> startup;
It works for me…
One response to “WARNING: AQ_TM_PROCESSES is set to 0. System operation might be adversely affected.”
Leave a comment
Free Storage
My Traffic
Recent Comments
 | Dennis on Change breadcrumb separator on… |
 | Mr. Miles on Windows 7: Install the same up… |
 | conorrobotham on “You do not have suffici… |
 | miles on Windows 7: Install the same up… |
 | acoi kumar on transfer pulsa 3 |
 | Paul A on Windows 7: Install the same up… |
Eric Wijaya 
Wow! Your site has a bunch comment posts. How did you get so many viewers to see your post I’m jealous! I’m still learning all about article writing on the web. I’m going to view pages on your website to get a better understanding how to achieve success. Thanks!