Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> What blocksize?
Hi,
I'm wondering what blocksize to use for a DB I'm creating. In the O'Reilly book they suggest:
"- Choose a small blocksize (2048 or 4096) for transaction systems where
there are frequent queries, inserts, and updates that involve a single
row.
- Choose large blocksize (8192 or larger) for data warehouses and other
large DB application where most data is bulk loaded, there are few
updates, and most queries return multiple rows or involve full table
scans"
I building a database driven website on Red Hat Linux 6, so neither of the above scenarios really fits my situation. The second one probably comes closer, so I'm thinking at the moment that 8192 would be preferable. I'd be interested to know what blocksize others have used for similar applications on the same platform.
TIA
![]() |
![]() |