Re: If db_block_size default - using size 8192

In <3n9efq$s26_at_newsbf02.news.aol.com> olywa_at_aol.com (Olywa) writes:

>My init.ora's and config.ora's don't have a db_block_size setting.
>According to Oracle 7 for Sun Sparc Solaris 2.x page 3-5, it then defaults
>to 2kb. I'm using Sparc array Vertisoft Volume Manager set block size to
>8192 for volumes with all Oracle data files and redo logs.
 

>Question: Is Oracle default to 2kb and disk formats at 8Kb a problem?

It isn't a *problem* per se, but it *can* result in less than optimal performance. However, the optimal db_block_size, the Unix filesystem blocksize (if you aren't using raw disk files), and the logical volume manager interleave (when you use striped disks) depend on *your* database. The same is generally true for all Oracle parameters; what works well for me may work very poorly for you.

If you are concerned about your database performance, your best bet would be to try changing various parameters until you get the combination that works best. Unfortunately, this is very time-consuming, since many critical parameters such as db_block_size and logical volume manager interleave require that you reinstall oracle and reinitialize the logical volume, respectively.

-- 
Fredrik Nyman  CACI  1120 G Street NW Suite 1000  Washington, DC 20005
"The Internet, for the uninitiated, is a collection of computer systems
at universities, nonprofit research groups, the federal government, and
some obscure businesses--all traditional hotbeds of hip, right?" SPY 8/94