How to tune Oracle queue messages wait time
Posted on 2003-03-09
I am having Oracle 8.1.7 Parallel Server Database(two instances). We are having major performance problems, then I ran the STATSPACK and found that queue nessages is having lot of wait time(97.8%). We are using Oracle Advanced Queuing.
If you have any idea how to tuning Queue Messages events, please let me know.