Re: Oracle Block Size and Solaris 2.6

Can you please tell me where you got this information that Oracle Now recommends 8-16k block sizes for most things? If it is from your Instructor, please give me his name and work phone number or e-mail address.

Just curious...not attacking your post at all. My Documentation "Oracle for Sun Performance Tuning Tips" (Part No. A25584-1) says on page 17: "We recommend a smaller Oracle database blocksizes (2k or 4k) for OLTP or mixed workload enviroments, and larger blocksizes (8k) for DSS type workloads."

Thanks,
Satar

In article <74e70f$9f8$1_at_nebula.mpn.com>,   sweh_at_mpn.com (Stephen Harris) wrote:
> Oracle used to recommend 2Kb for most stuff, and 16Kb for warehousing,
> but now they have changed their recommondation and say 8-16K is good
> for most things, wirth 32K or above for data warehousing.
>
> Block sizes are little to do with the data size itself, since oracle can store
> more than one row per data-block if required.
>
> Or so I was told on my DBA course earlier this year :-)
>
> Rgds
> Stephen
>

--
Oracle DBA/UNIX System Admin
Advanced Enterprise Solutions
(949) 756-0588
Oracle Re-Seller

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Dec 07 1998 - 15:24:29 CST