Init parameters for a large DW ...???

[Copernicus]

Hi,

I am working on a DW project and the size is like 2Tb with hundreds of users coming in from Cognos.I would like to use these INIT parameters.

Plz advise if this is good for 1 Tb database with 200 hundred users.
Thanks,
copericus
=======================
PGA_AGGREGATE_TARGET -> 1500 Mb
BUFFER_POOL_KEEP -> 500 Mb
BUFFER_POOL_RECYCLE -> 250 Mb
DB_CAHCE_SIZE in prod 1500 Mb
DB_CACHE_ADVICE -> ON
DB_FILE_MULTIBLOCK_READ_COUNT -> 32
HASH_JOIN_ENABLED -> TRUE
PARALLEL_MIN_SERVERS in prod -> 0
PARALLEL_MAX_SERVERS in prod -> 8
STAR_TRANSFORMATION_ENABLED -> true
QUERY_WRITE_ENABLED -> true
QUERY_REWRITE_INTEGRITY -> true
BIT_MAP_CREATE----> 64 Mb
LARGE_POOL_SIZE -> 64 Mb
========================

[tamilselvan]

I used the following values for my 600 GB DB.
BUFFER_POOL_KEEP -> 500 Mb
BUFFER_POOL_RECYCLE -> 500 Mb
DB_CAHCE_SIZE in prod 7000 Mb

Multiply DB_CACHE_SIZE by 3 for your DB.

Tamil

[slimdave]

"true" is not a valid value for query_rewrite_integrity.

buffer_pool_keep and buffer_pool_recycle: I would hold off on using these until you know what segments in the database are hot.

What's your block size?