RE: Db_block_checking (11.2)
- From: Jonathan Lewis <jonathan@xxxxxxxxxxxxxxxxxx>
- To: "hemantkchitale@xxxxxxxxx" <hemantkchitale@xxxxxxxxx>, ORACLE-L <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 7 Nov 2014 13:07:43 +0000
I don't think your result is particularly surprising - one of the guys at dbi
services produced some startling figures a couple of years ago:
http://www.dbi-services.com/index.php/blog/entry/protecting-an-oracle-database-from-block-corruption
But I think it can vary enormously with the nature of the work.
Regards
Jonathan Lewis
http://jonathanlewis.wordpress.com
@jloracle
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx [oracle-l-bounce@xxxxxxxxxxxxx] on behalf
of Hemant K Chitale [hemantkchitale@xxxxxxxxx]
Sent: 07 November 2014 00:08
To: ORACLE-L
Subject: Db_block_checking (11.2)
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:
