Oracle Parameter optimizer_index_cost_adj Performance

From Oracle Documentation, Default value 100 Modifiable ALTER SESSION, ALTER SYSTEM Range of values 1 to 10000 OPTIMIZER_INDEX_COST_ADJ lets you tune optimizer behavior for access path selection to be more or less index friendly—that is, to make the optimizer more or less prone to selecting an index access path over a full table scan. The [...]

Oracle Parameter db_block_checksum Performance

From Oracle Documentation, Default value TYPICAL Modifiable ALTER SYSTEM Range of values OFF | TYPICAL | FULL DB_BLOCK_CHECKSUM determines whether DBWn and the direct loader will calculate a checksum (a number calculated from all the bytes stored in the block) and store it in the cache header of every data block when writing it to [...]