On 06/11/2014 5:08 PM, Hemant K Chitale wrote:
If, as Tom says in https://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:1094433279412 , the checksum is calculated every time the block is written, and calculated every time it is read, and if the update causes blocks to be cleaned rapidly and unnecessarily (think "very poor Index Clustering Factor'") due to a relatively undersized SGA (relative to block cleanout requirements for the update operation), then it certainly could make sense that the overhead is dramatically high for the operation.What is the observed overhead of db_block_checking=TRUE (FULL) when running an UPDATE (1 to 3 columns) of almost all the rows of a table ? I see a 30% increase in CPU time.Sent from my smart phone. Hemant K Chitale
When you say "almost all rows", does that imply an index might be driving the selection or order or rows being updated?
/Hans