RE: Aq and wls 8
Date: Mon, 8 Feb 2010 08:41:48 +0200
Message-ID: <5BB479729855824B9A8B9724F455F70E010502DC08DC_at_ILPTMAIL02.ecitele.com>
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: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
On Behalf Of Ujang Jaenudin
Sent: Monday, February 08, 2010 2:26 AM
To: oracle-l_at_freelists.org
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
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Feb 08 2010 - 00:41:48 CST