Re: Setup initialization parameter in True64 Unix
Date: Wed, 27 Jun 2001 10:44:10 +0200
Message-ID: <9hc6cr$icl$1_at_news.tudelft.nl>
DB_BLOCK_SIZE : depends on the type of application OLTP,Data Warehouse and
have to be a multiple of your OS blocksize. For OLTP (Online Transaction
Processing) systems is advisable to have smaller block size assuming that
data requirement for information tend to be small and granular (Not every
process is using the same information of the same block). Contrary, for DSS
(Decision Support Systems) were reads tend to be large, a bigger database
block size will help in caching more information in memory with less I/O
accesses.
Usually between 4K and 16K.
This is a very important dissision before you create the database as it is
not easy to change it later on.
Another important dissision for the same reason is the CHARACTER SET.
CPU_COUNT : use default setting, oracle will automatically set this parameter.
DB_BLOCK_BUFFER: depends on the DB_BLOCK_SIZE you choose
SGA : a rule of thumb is that the sum of SGA's of the databases should not
exceed 1/2 of the physical RAM of the server. After that monitoring the
database (hit ratio's) will determine the optimal SGA for the databases.
SGA is made up by the following parameters
(db_block_buffers * block size) + (shared_pool_size + large_pool_size +
java_pool_size + log_buffers)
Bottom line : do some resarch on db_block_size and choose an appropriate value. The other parameters can be changed later on.
Rob. Received on Wed Jun 27 2001 - 10:44:10 CEST