Database DataWarehousing (MOSC)

MOSC Banner

Block size for data warehouse database

edited Oct 23, 2014 1:25PM in Database DataWarehousing (MOSC) 4 commentsAnswered

We are creating a data warehouse database 12.1.0.2 about 15 TB in size on RHEL6.

Is there any good practice about having database block size 8K, something bigger (16K for example) or a mix (8K for database tablespaces and 16K for the others)?

Thanks.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center