DB_BLOCK_CHECKING survey...
- From: <Christopher.Taylor2@xxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 29 Jan 2013 13:00:20 -0600
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
