Typical init.ora for an Oracle 9i data warehouse:

star_transformation_enabled

query_rewrite enabled

optimizer_features_enable 9.2.0

db_block_size 16384

parallel_automatic_tuning true

query_rewrite enabled

db_block_buffers 32768

db_file_multiblock_read_count 32

bitmap_merge_area_size 16777216

create_bitmap_area_size 16777216

compatible 9.0.1 or 9.2.0

hash_join_enabled true

job_queue_processes 10

enqueue_resources 3000

java_pool_size 40960000

dbwr_io_slaves 2xcpus

hash_area_size 1m

sort_area_size 16m

parallel_min_percent 59

parallel_min_servers w

parallel_max_servers more than 4cpus