Oracle 10.2.0.4 and HIGH dequeuing time for AQs
From: Pradeep Chetal <Pradeep.Chetal_at_mformation.com>
Date: Thu, 30 Apr 2009 06:35:59 -0400
Message-ID: <B1C751058F4E7C41BD50130B0750DD93015DF963_at_mfusemail01.mformation.com>
Date: Thu, 30 Apr 2009 06:35:59 -0400
Message-ID: <B1C751058F4E7C41BD50130B0750DD93015DF963_at_mfusemail01.mformation.com>
Hi,
We are using Oracle 10.2.0.4 and AQs and in some cases we see that our app threads take a long time to dequeue from AQs.
Has anyone else seen that? Are there any tuning parameters or patches, that will be great.
Thanks,
- Pradeep
Pradeep Chetal
Sr. Director - Infrastructure Architecture
Mformation Technologies Inc.
Switchboard: +1 732 692 6200
Visit WWW.MFORMATION.COM and see how the MFORMATION SERVICE MANAGER can help you to transform your business
Please consider the environment before printing
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Apr 30 2009 - 05:35:59 CDT