What checks occur each time the DBWnprocess(es) writes?

The DB_BLOCK_CHECKING parameter is set to FULL.
What checks occur each time the DBWnprocess(es) writes?

The DB_BLOCK_CHECKING parameter is set to FULL.
What checks occur each time the DBWnprocess(es) writes?

A.
The Oracle database will check all data blocks by going through the data on each block,
making sure the data is self-consistent.

B.
The DBWn and the direct loader will calculate a checksum and store it in the cache header of
every data block when writing it to disk.

C.
The Oracle database will check data blocks belonging to the SYSTEM tablespace only, by
going through the data on each block, making sure the data is self-consistent.

D.
The Oracle database will check data blocks belonging to the SYSAUX tablespace only, by
going through the data on each block, making sure the data is self-consistent.

E.
The Oracle database will check data blocks in the SYSTEM and SYSAUX tablespaces only, by
going through the data on each block, making sure the data is self-consistent.



Leave a Reply 1

Your email address will not be published. Required fields are marked *


goszczu

goszczu

A -right
docs:Oracle checks a block by going through the data in the block, making sure it is logically self-consistent.

B -wrong (?)
its definition for DB_BLOCK_CHECKSUM not DB_BLOCK_CHECKING

C-wrong, in FULL mode check is for all tablespaces

D-wrong

E-wrong