Tales From A Lazy Fat DBA

Den of an Oracle DB Performance freak & a fan of PostgreSQL & Cassandra …. \,,/

  • Likes

    • 148,962
  • Archives

  • ą„

  • Categories

  • Subscribe

  • Advertisements

DB_BLOCK_CHECKING, DB_BLOCK_CHECKSUM and

Posted by FatDBA on February 8, 2013

Well there are whole lot of changes when you start comparing Oracle 10g and 11g.Ā  DB_ULTRA_SAFE is one of the new parameter introduced in 11g which provides a mechanism to avoid block corruptions in your database. his parameter actually controls three parameters DB_BLOCK_CHECKING, DB_BLOCK_CHECKSUM & DB_LOST_WRITE_PROTECT parameters collectively.
Click on below provided links in order to read more about these three three initialization parameters.

DB_BLOCK_CHECKING

DB_BLOCK_CHECKSUM

DB_LOST_WRITE_PROTECT

Advertisements

2 Responses to “DB_BLOCK_CHECKING, DB_BLOCK_CHECKSUM and”

  1. oracleman consulting said

    they point to 11.1 docs, not 11.2 docs

    • oracleant said

      Hello Oracleman,
      Both DB_BLOCK_CHECKING and DB_BLOCK_CHECKSUM were available in 10g r2 as well except tha last DB_LOST_WRITE_PROTECT which was introduced in 11g r1.
      so they are available in 11g r2 as well without any change.

      Thanks for your time to read and comment.

      Thanks
      Prashant Dixit

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

 
%d bloggers like this: