Aq and wls 8

recently I got performance bottleneck on an audittrail database which hold all the transaction logging of our integration system due to log file sync

this db usually high insert volume and commit on per Trx basis which only 16kb

can we use aq, from bea juSt post messages to aq, and let plsql dequeue to batch insert to auditing table per 200 trx or per 5 sec whichever the first

is it possible?

Thanks for sharing

--

thanks and regards
ujang | oracle dba | mysql dba
jakarta - indonesia
--

http://www.freelists.org/webpage/oracle-l Received on Sun Feb 07 2010 - 18:25:39 CST