What is the DB_BLOCK_CHECKING parameter?

Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.

What is the DB_BLOCK_CHECKING parameter?

Rating:

DB_BLOCK_CHECKING is an instance parameter that helps in setting block checking at the database level. The default value of this parameter is false, but it can be set to true. When this parameter is set to false, it helps detect the damages caused by faulty memory. But when it is set to true, Oracle processes check the data block for consistency every time the buffer containing the block is accessed.

Note: Oracle recommends leaving the settings for this parameter to default unless there are tedious and specific issues pertaining to the corruptions taking place in the memory.


Rating:



Other articles

Click here to Article home

 
uCertify.com | Our Company | Articles | Privacy | Security | Contact Us | News and Press Release | uCertify India
MCSE: MCSA, MCTS, MCITP    JAVA Certification: SCJP, SCWCD Cisco Certification: CCNA, CCENT, A+, Network+, Security+
Oracle Certification: OCP 9i, OCP 10g, OCA 9i, OCA 10g CIW foundation    EC-212-32    CISSP    Photoshop ACE    Adobe Flash ACE
© 2008 uCertify.com. All rights reserved. All trademarks are the property of their respective owners.