UNDOCUMENTED INIT.ORA PARAMETER NOTES:

Parameter - Name of the undocumented parameter

Value - Current value for the parameter

Desc - Brief description of parameter

_ALLOW_RESETLOGS_CORRUPTION - This saves you when you have corrupted redo logs

_CORRUPTED_ROLLBACK_SEGMENTS - This saves you when you have corrupted RB segments

_SPIN_COUNT - This shows how often the processor will take a new request (reduce CPU timeouts)

_LOG_ENTRY_PREBUILD_THRESHOLD - Redo entries larger than this will be prebuilt

_LATCH_SPIN_COUNT - This shows how often a latch request will be taken (reduce latch timeouts)

_DB_BLOCK_WRITE_BATCH - Number of blocks to group in each DB Writer I/O

_CPU_COUNT - Number of CPUs that you have (causes bugs with Parallel Query option). Check with Oracle support for restrictions on some versions and O/S

_INIT_SQL_FILE - Where the sql.bsq file is located

_TRACE_FILES_PUBLIC - This allows users to see the TRACE output without major privileges

_FAST_FULL_SCAN_ENABLED - This allow indexed fast full scans if only indexes are needed

_CORRUPT_BLOCKS_ON_STUCK_RECOVERY - This sometimes gets a corrupted database up.

_ALWAYS_STAR_TRANSFORMATION - This is a fast method for Data Warehouse if you have a good designer.

_SMALL_TABLE_THRESHOLD - Small tables are pinned into memory if smaller than this

Do NOT change any of these values unless instructed by ORACLE support