Re: Siebel with Oracle DB

"JWC60084" <jwc60084_at_cs.com> wrote in message news:20000816205447.15308.00001235_at_ng-cp1.news.cs.com...
> >Subject: Siebel with Oracle DB
> >From: Jorge Meirim transparente_at_mail.telepac.pt
> >Date: 8/15/00 7:37 PM Central Daylight Time
> >Message-id: <3999E22D.CA25B7F9_at_mail.telepac.pt>
> >
> >Does any one know about a place where one can find more information
> >about
> >Siebel working with Oracle ? (tips, tunning, implementations ...)
> >
> >For example I would like to know what is the block size that most of the
> >
> >DBA's are working with.
> >The recommended by Siebel is 2K but there are many tables with more than
> >5K
> >total length.
> >
> >Any help would be apreciated
> >
> >Jorge Meirim
> >transparente_at_mail.telepac.pt
> >
> >
> >
> >
> >
>
> What os are you using unix, windows 2000, NT ? The db_block size parameter
 is a
> function of the highest blocksize allowable on your system and the most
> efficient for type of disk you have. On HP/UX 11.0 we are using 8K block
 size
> with EMC disk. In an NT implementation of a non-Siebel database we have
 used 2K
> blocksize. Kernel parameters in init.ora file are also important for
 Siebel
> performance.

8K is good for most Unixes, that's true. Not sure about that 2K on NT though.

For an authorative explanation of block sizes, see: http://www.ixora.com.au/tips/creation/block_size.htm

Regards
HJR Received on Fri Aug 18 2000 - 18:41:39 CDT