DB_BLOCK_CHECKING survey...
From: <Christopher.Taylor2_at_parallon.net>
Date: Tue, 29 Jan 2013 13:00:20 -0600
Message-ID: <F05D8DF1FB25F44085DB74CB916678E8857042F22B_at_NADCWPMSGCMS10.hca.corpad.net>
Finally had some time to check into a few task list items now that we've put out a few fires. One of my task list items was to review Oracle parameters for these systems I've been given with my new job. Obviously, that's a very amorphous kind of goal I know. Sort of a spot check really - kind of see what jumps out at me about things that are set and find out why they may be set a certain way.
Date: Tue, 29 Jan 2013 13:00:20 -0600
Message-ID: <F05D8DF1FB25F44085DB74CB916678E8857042F22B_at_NADCWPMSGCMS10.hca.corpad.net>
Finally had some time to check into a few task list items now that we've put out a few fires. One of my task list items was to review Oracle parameters for these systems I've been given with my new job. Obviously, that's a very amorphous kind of goal I know. Sort of a spot check really - kind of see what jumps out at me about things that are set and find out why they may be set a certain way.
One of the parameters that seems questionable [to me] is to have DB_BLOCK_CHECKING set to FALSE in all our environments (including the envs I'm not responsible for).
This 64-bit 10.2.0.4 on RHEL 5.6 - 3 node RAC.
I knew that Oracle recommended having it enabled at LOW, MEDIUM or FULL.
Since I'm relatively new to RAC, I'm curious what experience with it any of you RAC guys/gals might have? Any initial thoughts about not having it set? What levels do you have set for your envs?
Just scanning the landscape to see if anyone has any comments on the matter.
Chris Taylor
Oracle DBA
Parallon IT&S
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Jan 29 2013 - 20:00:20 CET