Jared,
That is correct the fields that are changed is known before going to this
point.
Bryan
P.S. I just want to say thank you for all the responses to this question. We
are still talking about the issue, but I am thankful for the input.
-----Original Message-----
Sent: Thursday, May 29, 2003 2:10 PM
To: Multiple recipients of list ORACLE-L
dunno about that. I was making the assumption that *which* columns
changed was already known.
This would require testing by someone familiar with the data.
Jared
"Jamadagni, Rajendra" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
05/29/2003 10:24 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: RE: Which method is more efficient
Jared,
Agreed, but what about the resources needs to find _which_ column changed
?? Would that offset the extra redo generated? Heck, I'd just generate the
update statements based on two tables to _only_ update the changed
columns. It is pretty easy, if both tables have _same_ columns ...
Raj
----------------------------------------------------------------------------
----
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !
-----Original Message-----
Sent: Wednesday, May 28, 2003 6:15 PM
To: Multiple recipients of list ORACLE-L
There are easier ways to test redo generation than mucking about with
logminer.
Update only the column that changes and check redo generation:
15:06:09 rsysdevdb.radisys.com - [EMAIL PROTECTED] SQL> @t1
[ much stuff deleted ]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Rodrigues, Bryan
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
