|
Welcome
Seminars
Consultancy
Calendar
Presentations
Diagnostics
Internals
References
Acknowledgements
|
Oracle 10.1 Supported Optimizer Environment
The V$SYS_OPTIMIZER_ENV family of views were added in Oracle 10.1
The following table shows the 25 optimizer parameters that was reported by the V$SYS_OPTIMIZER_ENV family of views in Oracle 10.1
|
| Name |
| active_instance_count |
| bitmap_merge_area_size |
| cpu_count |
| cursor_sharing |
| db_file_multiblock_read_count |
| hash_area_size |
| optimizer_dynamic_sampling |
| optimizer_features_enable |
| optimizer_index_caching |
| optimizer_index_cost_adj |
| optimizer_mode |
| parallel_ddl_mode |
| parallel_dml_mode |
| parallel_execution_enabled |
| parallel_query_mode |
| parallel_threads_per_cpu |
| pga_aggregate_target |
| query_rewrite_enabled |
| query_rewrite_integrity |
| skip_unusable_indexes |
| sort_area_retained_size |
| sort_area_size |
| star_transformation_enabled |
| statistics_level |
| workarea_size_policy |
|
|
