Re: Setup initialization parameter in True64 Unix

Ditto, but start small and only increase if you need to.

"rob" <rob_at_dsdelft.nl> wrote in message news: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 Sat Jul 07 2001 - 16:19:43 CEST