RE: Aq and wls 8

From: Amihay Gonen <>
Date: Mon, 8 Feb 2010 08:41:48 +0200
Message-ID: <>

I guess it can be done.
But are you sure this is going to solved your problem ?

Are you facing an issue of concurrency or I/O issue ? In case of the latter , I'm not sure the problem will disappear.    

In the extern case -
What you can do , it try to bypass the redolog , for example , you can ask that transaction logging will be written to a file and then use external table with direct loading ( you can load several files in one statement ) .

This of course will involve more coding (although 11g, give you a lot utilities which can reduce the amount of coding )

-----Original Message-----

From: [] On Behalf Of Ujang Jaenudin
Sent: Monday, February 08, 2010 2:26 AM
Subject: Aq and wls 8

Dear all,

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

-- Received on Mon Feb 08 2010 - 00:41:48 CST

Original text of this message