|
[oracle-l]
||
[Date Prev]
[11-2005 Date Index]
[Date Next]
||
[Thread Prev]
[11-2005 Thread Index]
[Thread Next]
RE: normalization
- From: "David Wendelken" <davewendelken@xxxxxxxxxxxxx>
- To: "'Oracle-L Freelists'" <Oracle-L@xxxxxxxxxxxxx>
- Date: Tue, 1 Nov 2005 21:45:21 -0500
>
>
>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.
>
Given that the reason the before row trigger fires is because we are FOR
SURE about to change the row, I would expect that we have to pay for the
lock ANYWAY...
--
http://www.freelists.org/webpage/oracle-l
|
