Major init.ora parameters used in a Data warehouse

PARALLEL_AUTOMATIC_TUNING: Oracle determines the default values for parameters that control parallel execution. In addition to setting this parameter, you must specify the
PARALLEL clause for the target tables in the system. Oracle then tunes all subsequent parallel operations automatically.

PARALLEL_ADAPTIVE_MULTI_USER: Enables an adaptive algorithm designed to improve performance in multi-user environments that use parallel execution. The algorithm automatically reduces the requested degree of parallelism based on the system load at query startup time. The effective degree of parallelism is based on the default degree of parallelism, or the degree from the table or hints, divided by a reduction factor.

PARALLEL_EXECUTION_MESSAGE_SIZE: specifies the size of messages for parallel execution. Larger values require a larger shared pool. Larger values result in better performance at the cost of higher memory use.

PARTITION_VIEW_ENABLED: specifies whether the optimizer uses partition views. If you set this parameter to true, the optimizer prunes (or skips) unnecessary table accesses in a partition view and alters the way it computes statistics on a partition view from statistics on underlying tables.

STAR_TRANSFORMATION_ENABLED: determines whether a cost-based query transformation will be applied to star queries

QUERY_REWRITE_ENABLED: allow you to enable or disable query rewriting globally for the database. To take advantage of query rewrite for a particular materialized view, you must enable query rewrite for that materialized view, and you must enable cost-based optimization.

QUERY_REWRITE_INTEGRITY: determines the degree to which Oracle must enforce query rewriting. At the safest level, Oracle does not use query rewrite transformations that rely on un-enforced relationships.