recomended extent sizes

[Beantree]

What would be the recomended extent sizes for a data warehouse?

I believe it's appropriate to have at least 2 standard sizes to accomodate large and small tables.

I thought I read somewhere to use 160 Kb and 160 Mb.

This is on W2K Server, 9i DB.

Thanks.

 

[Wonboodoo]

I read the same document as you I think:
160K for small tables
5120K for medium tables (tables over 5M in total size)
160M for big tables (tables over 160M in total size)
It's desirable to keep the different sized tables in different tables spaces. i.e. have three tablespaces for tables. This prevents fragmentation within tablespaces.

Same holds true for indexes.

 

[appi]

Hi,

but sometimes you should take care if there are fix data or variable data. If the data is changing and you've small extent-sizes, you got the problem that you'll reach the limit #, if you'd big size and need many the maximum space is reached. So you need to review maybe after 6 month productivity if any setting seems okay.
rgds
Uwe