Re: Oracle direction on triggers

From: Sybrand Bakker <gooiditweg_at_nospam.demon.nl>
Date: Tue, 25 Feb 2003 20:02:08 +0100
Message-ID: <bcfn5vcp2dk3fqutidi5lg66i7c82ojcdi@4ax.com>

On Tue, 25 Feb 2003 07:31:51 -0600, Ed Stevens <nospam_at_noway.nohow> wrote:

>That's exactly the situation. So of course the transaction does have
>to wait, but for how long? One microsecond? One second? One mintue?
>I should have taken responsibility for benchmarking, and failed to do
>so. On the other hand, the analyst has not been able to say if or how
>much the app has been impacted, which leads me to believe that the
>impact is not measurable. This is certainly not the first app in the
>shop to write thru the gateway to DB2 -- just the first to implement
>it via a trigger instead of app code.

Objection waived. Oracle 8i comes with autonomous transactions. They are basically asynchronous.

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Tue Feb 25 2003 - 13:02:08 CST