Database server

	Recommendations \| Performance papers

	Initialization parameters used for Oracle I/O option measurements
	Miscellaneous settings
	Selecting the test scenario

	I/O options
	Relink Oracle for async I/O

Initialization parameters used for Oracle I/O option measurements

These settings are commonly used for all test scenarios.

Parameter	Value	Comment
DB_BUFFER_SIZE	0.6 * memory size
DB_FILE_MULTIBLOCK_READ_COUNT	0	#	no read ahead!
AQ_TM_PROCESSES	0	#	0 or 1 has no performance impact
LOG_BUFFER	54M	#	this reduces the throughput if too small, but larger values do not result in any improvement; workload dependent

Team

Please address any comments to the performance team: linux390@de.ibm.com