RE: normalization

From: Steve Adams <steve.adams_at_ixora.com.au>
Date: Wed, 2 Nov 2005 12:43:30 +1100
Message-ID: <001601c5df4e$d3b19180$0a0a0a0a@ixora.com.au>

BEFORE ROW triggers also need to lock each target row, even if nothing is done. This doubles the number of current mode buffer gets and increases redo generation significantly.

@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/ - For DBAs
@ http://www.christianity.net.au/ - For all

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jared Still Sent: Wednesday, 2 November 2005 12:07 PM To: stephenbooth.uk_at_gmail.com
Cc: mark.powell_at_eds.com; Oracle-L Freelists Subject: Re: normalization

[snip]

BEFORE UPDATE triggers have their own set of problems, and should be used judiciously. I'm sure many of us (me) have used them in the past more than they should have been.

http://tkyte.blogspot.com/2005/08/part-ii-seeing-restart.html http://tkyte.blogspot.com/2005/09/part-iii-why-is-restart-important-to.html

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Nov 01 2005 - 19:45:53 CST