Sean,
There is a small overhead with both DB_BLOCK_CHECKSUM
and LOG_BLOCK_CHECKSUM as Oracle has to compute and
store the checksum of the block in the block every
time it is written to disk. When the block is read
its checksum is computed again and compared to the
value stored in the block.
The following note on MetaLink has an excellent
discussion of these parameters:
Note: 32969.1 - "TECH: Database Block Checking
Features"
HTH,
- Anita
- "O'Neill, Sean" <Sean.ONeill_at_organon.ie> wrote:
> Hi Folks,
>
> Are the questions below part of some FAQ set or
> perhaps to-date unexplored
> and not familiar. Just wunderin' cuz I got zilch
> replies!
>
> - Sean
>
> -----Original Message-----
> Sent: Thursday, July 13, 2000 12:37
> To: 'List, OracleDBA [Fatcity]'
>
>
> Given the function of the LOG_BLOCK_CHECKSUM when it
> is set to TRUE does
> anyone know why it's default value is FALSE?. Is
> there some unacceptable
> overhead involved or what?
>
> Also, are there any other database parameters which
> have default values
> which you think are best changed up/down or switched
> on?
>
> Hhhhhhmmmm.... now wondering if the default
> parameter values are consistent
> throughout various releases???
>
>
> Regards,
> Sean :)
>
> ###### ###### ###### ######
> # # # # # # # # Rookie
> #### # # ###### ###### Data
> # # # # # # # # Base
> # # ####### ###### # # Adminstrator
> -------------------------------- ------------
> Organon (Ireland) Ltd.
> E-mail: sean.oneill_at_organon.ie [subscribed: Digest
> Mode]
>
> The only man who never makes a mistake is the man
> who never does anything.
> - Theodore Roosevelt
>
> --
> Author: O'Neill, Sean
> INET: Sean.ONeill_at_organon.ie
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
Do You Yahoo!?
Received on Mon Jul 17 2000 - 06:47:10 CDT
