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...
--
//www.freelists.org/webpage/oracle-l
Other related posts:
