Tales From A Lazy Fat DBA

Its all about Databases & their performance, troubleshooting & much more …. ¯\_(ツ)_/¯

«
»

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

Advertisement

This entry was posted on February 8, 2013 at 10:24 AM and is filed under Advanced. Tagged: . You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

2 Responses to “DB_BLOCK_CHECKING, DB_BLOCK_CHECKSUM and”

  1. oracleman consulting said

    February 8, 2013 at 10:33 AM

    they point to 11.1 docs, not 11.2 docs

    Reply

    • oracleant said

      February 8, 2013 at 10:39 AM

      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

      Reply

Leave a Reply

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

Gravatar
WordPress.com Logo

You are commenting using your WordPress.com 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 )

Cancel

Connecting to %s

«
»
 
%d bloggers like this: