Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: What blocksize?
Kevin,
You do fit the scenarios. You fall into the OLTP category. If we just
compare
quierie for OLTP versus DW, you fall into OLTP. OLTP is characterized by
lots of small, isolated database read/writes. DW's are charaterized by a few
large database read or writes. For example, OLTP, get 2 records from table
A to go with 5 records from table B and 10 records from table C. For the
DW, a typcial query would be to fetch 50 rows from table A to go with
500,000 rows from table B. As a web application, you will clearly fall
more into the first category -- OLTP. That said, pick 4096 for OLTP.
If you had been a DW, then 8192 would be more appropriate. The old
default of 2048 is a default from way back and is no longer a good choice
EVER for UNIX, NT or just about any other platform.
for DW.
Received on Wed Aug 18 1999 - 08:48:23 CDT