Re: Block size reccomendations

From: Wong, Gordon <WongGo_at_STAPLES.COM>
Date: Mon, 12 Feb 1996 09:23:04 -0500
Message-Id: <9602121429.AA11886@alice.jcc.com>

Hello,

     Actually Oracle recommends that your database block size match or be multiple of your operating system block size. What you actually chose should depend on the type of application you are running. Lots of small transaction, small block size. Fewer but larger transactions, large block size.

Cheers,

Gordon

---

From: ORACLE database mailing list.
To: Multiple recipients of list ORA
Subject: Re: Block size reccomendations Date: Monday, February 12, 1996 9:09AM

Hi there,

    I believe that oracle suggests that your database Block Size match that of your O/S Block Size. If I remember correctly its in 2K, 4K, 8K or 16K.. I'd talk to your Sysadmin for the HP 9000 and have them match...

A.J.Miller / LDBA
Burlington Coat Factory

> From owner-oracle-l_at_CCVM.SUNYSB.EDU Thu Feb 8 11:08:08 1996
> Reply-To: "ORACLE database mailing list." <ORACLE-L_at_CCVM.SUNYSB.EDU>
> Sender: "ORACLE database mailing list." <ORACLE-L_at_CCVM.SUNYSB.EDU>
> Subject: Block size reccomendations
> X-To: oraworld <oracle-l_at_CCVM.SUNYSB.EDU>
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_CCVM.SUNYSB.EDU>
> Content-Length: 255
> X-Lines: 8
>
> We are looking to move PeopleSoft Financials (AP and GL) to an HP 9000.
 At
> which time we ill get to re-create the base database.
> I'm looking for block size recomendations for this package on HP: 4K or 8K
> ????
> Thanks for the input.
>
> Dave
> dlt3716_at_kcpl.com
>

• Message Header Follows ------ Received: from gw.staples.com by staples.com (PostalUnion/SMTP(tm) v2.1.6 for Windows NT(tm)) id AA-1996Feb12.090911.1057.46310; Mon, 12 Feb 1996 09:09:11 -0500 Received: by gw.staples.com; id JAA05271; Mon, 12 Feb 1996 09:08:14 -0500 Message-Id: <199602121408.JAA05271_at_gw.staples.com> Received: from ccvm.sunysb.edu(129.49.2.183) by gw.staples.com via smap (g3.0.1) id xma005267; Mon, 12 Feb 96 09:07:55 -0500 Received: from CCVM.SUNYSB.EDU by ccvm.sunysb.edu (IBM VM SMTP V2R3) with BSMTP id 0546; Mon, 12 Feb 96 08:52:32 EST Received: from CCVM.SUNYSB.EDU (NJE origin LISTSERV_at_SBCCVM) by CCVM.SUNYSB.EDU (LMail V1.2a/1.8a) with BSMTP id 4066; Mon, 12 Feb 1996 08:51:59 -0500 Date: Mon, 12 Feb 1996 08:51:21 +0500 Reply-To: "ORACLE database mailing list." <ORACLE-L_at_ccvm.sunysb.edu> Sender: "ORACLE database mailing list." <ORACLE-L_at_ccvm.sunysb.edu> From: "Almore J. Miller III" <ajmiller_at_HYDRA.COAT.COM> Subject: Re: Block size reccomendations X-To: ORACLE-L_at_CCVM.SUNYSB.EDU To: Multiple recipients of list ORACLE-L <ORACLE-L_at_ccvm.sunysb.edu>

Received on Mon Feb 12 1996 - 09:29:28 CST