Db_block_checking (11.2)

From: Hemant K Chitale <hemantkchitale_at_gmail.com>
Date: Fri, 7 Nov 2014 08:08:41 +0800
Message-ID: <CAMNBsZsN7wO==Zck1vxPq19i-0j+AN2qA1FSqEQu5WZzE5C0DA_at_mail.gmail.com>



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

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Nov 07 2014 - 01:08:41 CET

Original text of this message