From: "Robert Fazio" Newsgroups: comp.databases.oracle References: <1ddc56b5.0106261911.23fed6dd@posting.google.com> <9hc6cr$icl$1@news.tudelft.nl> Subject: Re: Setup initialization parameter in True64 Unix Lines: 39 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.50.4522.1200 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200 Message-ID: <3UE17.2592$Y6.957744@news1.rdc2.pa.home.com> Date: Sat, 07 Jul 2001 14:19:43 GMT NNTP-Posting-Host: 24.8.218.197 X-Complaints-To: abuse@home.net X-Trace: news1.rdc2.pa.home.com 994515583 24.8.218.197 (Sat, 07 Jul 2001 07:19:43 PDT) NNTP-Posting-Date: Sat, 07 Jul 2001 07:19:43 PDT Organization: Excite@Home - The Leader in Broadband http://home.com/faster Ditto, but start small and only increase if you need to. "rob" wrote in message news:9hc6cr$icl$1@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. > > >