PARTITION_VIEW_ENABLED

Parameter type:	Boolean
Parameter class:	Dynamic. Scope = ALTER SESSION.
Default value:	FALSE
Range of values:	TRUE | FALSE
Note: Oracle Corporation recommends that you use partitioned tables (available beginning with Oracle8) rather than partition views. Partition views are supported for backward compatibility only.
PARTITION_VIEW_ENABLED specifies whether the optimizer uses partition views. If you set it 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.
See Also: Oracle8i Concepts for information on the advantages of partitioned tables, and how to convert partition views to partitioned tables.