Db_block_checking (11.2)

  • From: Hemant K Chitale <hemantkchitale@xxxxxxxxx>
  • To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 7 Nov 2014 08:08:41 +0800

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

Other related posts: