Re: Aq and wls 8
- From: Ujang Jaenudin <ujang.jaenudin@xxxxxxxxx>
- To: Amihay Gonen <Amihay.Gonen@xxxxxxxxxxx>
- Date: Mon, 8 Feb 2010 17:36:42 +0700
Ami,
from awr the latency of io is about 144ms for 16kb redo per trx commit
during batch processing and during online processing is about 10ms
so, it is app issue but I am trying to handle it by aq :)
On Monday, February 8, 2010, Amihay Gonen <Amihay.Gonen@xxxxxxxxxxx> wrote:
> 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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
> On Behalf Of Ujang Jaenudin
> Sent: Monday, February 08, 2010 2:26 AM
> To: oracle-l@xxxxxxxxxxxxx
> 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
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
thanks and regards
ujang | oracle dba | mysql dba
jakarta - indonesia
--
//www.freelists.org/webpage/oracle-l
Other related posts:
