- Yes. A (smallfile) datafile can have approx 4 million blocks.
Personally I use 8k blocks for everything. It is the middle of the
road size and doesn't put you in an edge condition. If you want
larger IOs in a DW, adjust the multi block read accordingly.
- From a performance view, having fewer files lowers the file
descriptor requirement, but it may impact the recovery strategy - now
a single file recovery will take longer due to the increased size.
--
Regards,
Greg Rahn
http://structureddata.org
On Jun 10, 10:37 am, "Dereck L. Dietz" <diet..._at_ameritech.net> wrote:
> Would I be correct in making the following two assumptions?
>
> 1. If using a 16K block size then the data files could go up to 64GB.
>
> 2. Fewer but larger data files are preferable over more but smaller data
> files.
Received on Sun Jun 10 2007 - 13:11:45 CDT
