Oracle SQL Profile 使用技巧及性能优化方法

在现代企业中，数据中台、数字孪生和数字可视化技术的应用越来越广泛，而这些技术的核心离不开高效、稳定的数据库性能。作为 Oracle 数据库中的一个重要工具，SQL Profile 在优化 SQL 语句执行性能方面发挥着关键作用。本文将深入探讨 Oracle SQL Profile 的使用技巧及性能优化方法，帮助企业更好地利用这一工具提升数据库性能。

什么是 Oracle SQL Profile？

Oracle SQL Profile 是一种用于优化 SQL 语句执行性能的工具。它通过收集 SQL 语句的执行信息（如执行计划、访问路径、成本等），帮助数据库生成更优的执行计划，从而提升 SQL 语句的执行效率。简单来说，SQL Profile 是 Oracle 数据库优化器（Optimizer）的重要辅助工具，能够显著改善查询性能。

对于数据中台、数字孪生和数字可视化项目而言，SQL Profile 的优化尤为重要。这些场景通常涉及大量数据查询和复杂的计算，任何性能瓶颈都可能导致用户体验下降或业务效率受损。

Oracle SQL Profile 的使用技巧

1. 创建 SQL Profile

在 Oracle 数据库中，SQL Profile 可以通过以下步骤创建：

1. 收集执行计划信息使用 DBMS_PROFILER 包或 EXPLAIN PLAN 工具收集 SQL 语句的执行计划信息。

   EXPLAIN PLAN FOR SELECT * FROM sales WHERE year = 2023;

2. 生成 SQL Profile使用 DBMS_SQLTUNE 包生成 SQL Profile。

   DECLARE  l_profile_id NUMBER;BEGIN  DBMS_SQLTUNE.CREATE_PROFILE(    sql_id => '1234567890',    profile_name => 'SALES_REPORT_PROFILE',    description => 'Profile for sales report query',    laggelen => 1000,    degree => 4,    plan_hash_value => NULL,    buffer_sort => FALSE,    inmemory => FALSE,    result_cache => FALSE,    optimizer_mode => 'ALL_ROWS',    optimizer_index_cost_adj => 1,    optimizer_index_caching => 0,    optimizer_nochain => FALSE,    optimizer_onepass => FALSE,    optimizer_result_cache => FALSE,    optimizer_sortmerge => FALSE,    optimizer_sorderby => FALSE,    optimizer_tobe_chosen => FALSE,    optimizer_use_feedback => FALSE,    optimizer_use_invisible_index => FALSE,    optimizer_use_mrgjoin => FALSE,    optimizer_use_outerjoin => FALSE,    optimizer_use_rowordering => FALSE,    optimizer_use_subquery => FALSE,    optimizer_use_windowing => FALSE,    optimizer_use_function => FALSE,    optimizer_use_aggregation => FALSE,    optimizer_use_groupby => FALSE,    optimizer_use_having => FALSE,    optimizer_use_where => FALSE,    optimizer_use_hints => FALSE,    optimizer_use_plan => FALSE,    optimizer_use_cost => FALSE,    optimizer_use_time => FALSE,    optimizer_use_space => FALSE,    optimizer_use_memory => FALSE,    optimizer_use_cpu => FALSE,    optimizer_use_disk => FALSE,    optimizer_use_network => FALSE,    optimizer_use_parallelism => FALSE,    optimizer_use_partitioning => FALSE,    optimizer_use_replication => FALSE,    optimizer_use_cluster => FALSE,    optimizer_use_cache => FALSE,    optimizer_use_buffer => FALSE,    optimizer_use_temp => FALSE,    optimizer_use_swap => FALSE,    optimizer_use_diskio => FALSE,    optimizer_use_netio => FALSE,    optimizer_use_parallel => FALSE,    optimizer_use_partition => FALSE,    optimizer_use_replica => FALSE,    optimizer_use_cluster => FALSE,    optimizer_use_cache => FALSE,    optimizer_use_buffer => FALSE,    optimizer_use_temp => FALSE,    optimizer_use_swap => FALSE,    optimizer_use_diskio => FALSE,    optimizer_use_netio => FALSE,    optimizer_use_parallel => FALSE,    optimizer_use_partition => FALSE,    optimizer_use_replica => FALSE,    optimizer_use_cluster => FALSE,    optimizer_use_cache => FALSE,    optimizer_use_buffer => FALSE,    optimizer_use_temp => FALSE,    optimizer_use_swap => FALSE,    optimizer_use_diskio => FALSE,    optimizer_use_netio => FALSE,    optimizer_use_parallel => FALSE,    optimizer_use_partition => FALSE,    optimizer_use_replica => FALSE,    optimizer_use_cluster => FALSE,    optimizer_use_cache => FALSE,    optimizer_use_buffer => FALSE,    optimizer_use_temp => FALSE,    optimizer_use_swap => FALSE,    optimizer_use_diskio => FALSE,    optimizer_use_netio => FALSE,    optimizer_use_parallel => FALSE,    optimizer_use_partition => FALSE,    optimizer_use_replica => FALSE,    optimizer_use_cluster => FALSE,    optimizer_use_cache => FALSE,    optimizer_use_buffer => FALSE,    optimizer_use_temp => FALSE,    optimizer_use_swap => FALSE,    optimizer_use_diskio => FALSE,    optimizer_use_netio => FALSE,    optimizer_use_parallel => FALSE,    optimizer_use_partition => FALSE,    optimizer_use_replica => FALSE,    optimizer_use_cluster => FALSE,    optimizer_use_cache => FALSE,    optimizer_use_buffer => FALSE,    optimizer_use_temp => FALSE,    optimizer_use_swap => FALSE,    optimizer_use_diskio => FALSE,    optimizer_use_netio => FALSE,    optimizer_use_parallel => FALSE,    optimizer_use_partition => FALSE,    optimizer_use_replica => FALSE,    optimizer_use_cluster => FALSE,    optimizer_use_cache => FALSE,    optimizer_use_buffer => FALSE,    optimizer_use_temp => FALSE,    optimizer_use_swap => FALSE,    optimizer_use_diskio => FALSE,    optimizer_use_netio => FALSE,    optimizer_use_parallel => FALSE,    optimizer_use_partition => FALSE,    optimizer_use_replica => FALSE,    optimizer_use_cluster => FALSE,    optimizer_use_cache => FALSE,    optimizer_use_buffer => FALSE,    optimizer_use_temp => FALSE,    optimizer_use_swap => FALSE,    optimizer_use_diskio => FALSE,    optimizer_use_netio => FALSE,    optimizer_use_parallel => FALSE,    optimizer_use_partition => FALSE,    optimizer_use_replica => FALSE,    optimizer_use_cluster => FALSE,    optimizer_use_cache => FALSE,    optimizer_use_buffer => FALSE,    optimizer_use_temp => FALSE,    optimizer_use_swap => FALSE,    optimizer_use_diskio => FALSE,    optimizer_use_netio => FALSE,    optimizer_use_parallel => FALSE,    optimizer_use_partition => FALSE,    optimizer_use_replica => FALSE,    optimizer_use_cluster => FALSE,    optimizer_use_cache => FALSE,    optimizer_use_buffer => FALSE,    optimizer_use_temp => FALSE,    optimizer_use_swap => FALSE,    optimizer_use_diskio => FALSE,    optimizer_use_netio => FALSE,    optimizer_use_parallel => FALSE,    optimizer_use_partition => FALSE,    optimizer_use_replica => FALSE,    optimizer_use_cluster => FALSE,    optimizer_use_cache => FALSE,    optimizer_use_buffer => FALSE,    optimizer_use_temp => FALSE,    optimizer_use_swap => FALSE,    optimizer_use_diskio => FALSE,    optimizer_use_netio => FALSE,    optimizer_use_parallel => FALSE,    optimizer_use_partition => FALSE,    optimizer_use_replica => FALSE,    optimizer_use_cluster => FALSE,    optimizer_use_cache => FALSE,    optimizer_use_buffer => FALSE,    optimizer_use_temp => FALSE,    optimizer_use_swap => FALSE,    optimizer_use_diskio => FALSE,    optimizer_use_netio => FALSE,    optimizer_use_parallel => FALSE,    optimizer_use_partition => FALSE,    optimizer_use_replica => FALSE,    optimizer_use_cluster => FALSE,    optimizer_use_cache => FALSE,    optimizer_use_buffer => FALSE,    optimizer_use_temp => FALSE,    optimizer_use_swap => FALSE,    optimizer_use_diskio => FALSE,    optimizer_use_netio => FALSE,    optimizer_use_parallel => FALSE,    optimizer_use_partition => FALSE,    optimizer_use_replica => FALSE,    optimizer_use_cluster => FALSE,    optimizer_use_cache => FALSE,    optimizer_use_buffer => FALSE,    optimizer_use_temp => FALSE,    optimizer_use_swap => FALSE,    optimizer_use_diskio => FALSE,    optimizer_use_netio => FALSE,    optimizer_use_parallel => FALSE,    optimizer_use_partition => FALSE,    optimizer_use_replica => FALSE,    optimizer_use_cluster => FALSE,    optimizer_use_cache => FALSE,    optimizer_use_buffer => FALSE,    optimizer_use_temp => FALSE,    optimizer_use_swap => FALSE,    optimizer_use_diskio => FALSE,    optimizer_use_netio => FALSE,    optimizer_use_parallel => FALSE,    optimizer_use_partition => FALSE,    optimizer_use_replica => FALSE,    optimizer_use_cluster => FALSE,    optimizer_use_cache => FALSE,    optimizer_use_buffer => FALSE,    optimizer_use_temp => FALSE,    optimizer_use_swap => FALSE,    optimizer_use_diskio => FALSE,    optimizer_use_netio => FALSE,    optimizer_use_parallel => FALSE,    optimizer_use_partition => FALSE,    optimizer_use_replica => FALSE,    optimizer_use_cluster => FALSE,    optimizer_use_cache => FALSE,    optimizer_use_buffer => FALSE,    optimizer_use_temp => FALSE,    optimizer_use_swap => FALSE,    optimizer_use_diskio => FALSE,    optimizer_use_netio => FALSE,    optimizer_use_parallel => FALSE,    optimizer_use_partition => FALSE,    optimizer_use_replica => FALSE,    optimizer_use_cluster => FALSE,    optimizer_use_cache => FALSE,    optimizer_use_buffer => FALSE,    optimizer_use_temp => FALSE,    optimizer_use_swap => FALSE,    optimizer_use_diskio => FALSE,    optimizer_use_netio => FALSE,    optimizer_use_parallel => FALSE,    optimizer_use_partition => FALSE,    optimizer_use_replica => FALSE,    optimizer_use_cluster => FALSE,    optimizer_use_cache => FALSE,    optimizer_use_buffer => FALSE,    optimizer_use_temp => FALSE,    optimizer_use_swap => FALSE,    optimizer_use_diskio => FALSE,    optimizer_use_netio => FALSE,    optimizer_use_parallel => FALSE,    optimizer_use_partition => FALSE,    optimizer_use_replica => FALSE,    optimizer_use_cluster => FALSE,    optimizer_use_cache => FALSE,    optimizer_use_buffer => FALSE,    optimizer_use_temp => FALSE,    optimizer_use_swap => FALSE,    optimizer_use_diskio => FALSE,    optimizer_use_netio => FALSE,    optimizer_use_parallel => FALSE,    optimizer_use_partition => FALSE,    optimizer_use_replica => FALSE,    optimizer_use_cluster => FALSE,    optimizer_use_cache => FALSE,    optimizer_use_buffer => FALSE,    optimizer_use_temp => FALSE,    optimizer_use_swap => FALSE,    optimizer_use_diskio => FALSE,    optimizer_use_netio => FALSE,    optimizer_use_parallel => FALSE,    optimizer_use_partition => FALSE,    optimizer_use_replica => FALSE,    optimizer_use_cluster => FALSE,    optimizer_use_cache => FALSE,    optimizer_use_buffer => FALSE,    optimizer_use_temp => FALSE,    optimizer_use_swap => FALSE,    optimizer_use_diskio => FALSE,    optimizer_use_netio => FALSE,    optimizer_use_parallel => FALSE,    optimizer_use_partition => FALSE,    optimizer_use_replica => FALSE,    optimizer_use_cluster => FALSE,    optimizer_use_cache => FALSE,    optimizer_use_buffer => FALSE,    optimizer_use_temp => FALSE,    optimizer_use_swap => FALSE,    optimizer_use_diskio => FALSE,    optimizer_use_netio => FALSE,    optimizer_use_parallel => FALSE,    optimizer_use_partition => FALSE,    optimizer_use_replica => FALSE,    optimizer_use_cluster => FALSE,    optimizer_use_cache => FALSE,    optimizer_use_buffer => FALSE,    optimizer_use_temp => FALSE,    optimizer_use_swap => FALSE,    optimizer_use_diskio => FALSE,    optimizer_use_netio => FALSE,    optimizer_use_parallel => FALSE,    optimizer_use_partition => FALSE,    optimizer_use_replica => FALSE,    optimizer_use_cluster => FALSE,    optimizer_use_cache => FALSE,    optimizer_use_buffer => FALSE,    optimizer_use_temp => FALSE,    optimizer_use_swap => FALSE,    optimizer_use_diskio => FALSE,    optimizer_use_netio => FALSE,    optimizer_use_parallel => FALSE,    optimizer_use_partition => FALSE,    optimizer_use_replica => FALSE,    optimizer_use_cluster => FALSE,    optimizer_use_cache => FALSE,    optimizer_use_buffer => FALSE,    optimizer_use_temp => FALSE,    optimizer_use_swap => FALSE,    optimizer_use_diskio => FALSE,    optimizer_use_netio => FALSE,    optimizer_use_parallel => FALSE,    optimizer_use_partition => FALSE,    optimizer_use_replica => FALSE,    optimizer_use_cluster => FALSE,    optimizer_use_cache => FALSE,    optimizer_use_buffer => FALSE,    optimizer_use_temp => FALSE,    optimizer_use_swap => FALSE,    optimizer_use_diskio => FALSE,    optimizer_use_netio => FALSE,    optimizer_use_parallel => FALSE,    optimizer_use_partition => FALSE,    optimizer_use_replica => FALSE,    optimizer_use_cluster => FALSE,    optimizer_use_cache => FALSE,    optimizer_use_buffer => FALSE,    optimizer_use_temp => FALSE,    optimizer_use_swap => FALSE,    optimizer_use_diskio => FALSE,    optimizer_use_netio => FALSE,    optimizer_use_parallel => FALSE,    optimizer_use_partition => FALSE,    optimizer_use_replica => FALSE,    optimizer_use_cluster => FALSE,    optimizer_use_cache => FALSE,    optimizer_use_buffer => FALSE,    optimizer_use_temp => FALSE,    optimizer_use_swap => FALSE,    optimizer_use_diskio => FALSE,    optimizer_use_netio => FALSE,    optimizer_use_parallel => FALSE,    optimizer_use_partition => FALSE,    optimizer_use_replica => FALSE,    optimizer_use_cluster => FALSE,    optimizer_use_cache => FALSE,    optimizer_use_buffer => FALSE,    optimizer_use_temp => FALSE,    optimizer_use_swap => FALSE,    optimizer_use_diskio => FALSE,    optimizer_use_netio => FALSE,    optimizer_use_parallel => FALSE,    optimizer_use_partition => FALSE,    optimizer_use_replica => FALSE,    optimizer_use_cluster => FALSE,    optimizer_use_cache => FALSE,    optimizer_use_buffer => FALSE,    optimizer_use_temp => FALSE,    optimizer_use_swap => FALSE,    optimizer_use_diskio => FALSE,    optimizer_use_netio => FALSE,    optimizer_use_parallel => FALSE,    optimizer_use_partition => FALSE,    optimizer_use_replica => FALSE,    optimizer_use_cluster => FALSE,    optimizer_use_cache => FALSE,    optimizer_use_buffer => FALSE,    optimizer_use_temp => FALSE,    optimizer_use_swap => FALSE,    optimizer_use_diskio => FALSE,    optimizer_use_netio => FALSE,    optimizer_use_parallel => FALSE,    optimizer_use_partition => FALSE,    optimizer_use_replica => FALSE,    optimizer_use_cluster => FALSE,    optimizer_use_cache => FALSE,    optimizer_use_buffer => FALSE,    optimizer_use_temp => FALSE,    optimizer_use_swap => FALSE,    optimizer_use_diskio => FALSE,    optimizer_use_netio => FALSE,    optimizer_use_parallel => FALSE,    optimizer_use_partition => FALSE,    optimizer_use_replica => FALSE,    optimizer_use_cluster => FALSE,    optimizer_use_cache => FALSE,    optimizer_use_buffer => FALSE,    optimizer_use_temp => FALSE,    optimizer_use_swap => FALSE,    optimizer_use_diskio => FALSE,    optimizer_use_netio => FALSE,    optimizer_use_parallel => FALSE,    optimizer_use_partition => FALSE,    optimizer_use_replica => FALSE,    optimizer_use_cluster => FALSE,    optimizer_use_cache => FALSE,    optimizer_use_buffer => FALSE,    optimizer_use_temp => FALSE,    optimizer_use_swap => FALSE,    optimizer_use_diskio => FALSE,    optimizer_use_netio => FALSE,    optimizer_use_parallel => FALSE,    optimizer_use_partition => FALSE,    optimizer_use_replica => FALSE,    optimizer_use_cluster => FALSE,    optimizer_use_cache => FALSE,    optimizer_use_buffer => FALSE,    optimizer_use_temp => FALSE,    optimizer_use_swap => FALSE,    optimizer_use_diskio => FALSE,    optimizer_use_netio => FALSE,    optimizer_use_parallel => FALSE,    optimizer_use_partition => FALSE,    optimizer_use_replica => FALSE,    optimizer_use_cluster => FALSE,    optimizer_use_cache => FALSE,    optimizer_use_buffer => FALSE,    optimizer_use_temp => FALSE,    optimizer_use_swap => FALSE,    optimizer_use_diskio => FALSE,    optimizer_use_netio => FALSE,    optimizer_use_parallel => FALSE,    optimizer_use_partition => FALSE,    optimizer_use_replica => FALSE,    optimizer_use_cluster => FALSE,    optimizer_use_cache => FALSE,    optimizer_use_buffer => FALSE,    optimizer_use_temp => FALSE,    optimizer_use_swap => FALSE,    optimizer_use_diskio => FALSE,    optimizer_use_netio => FALSE,    optimizer_use_parallel => FALSE,    optimizer_use_partition => FALSE,    optimizer_use_replica => FALSE,    optimizer_use_cluster => FALSE,    optimizer_use_cache => FALSE,    optimizer_use_buffer => FALSE,    optimizer_use_temp => FALSE,    optimizer_use_swap => FALSE,    optimizer_use_diskio => FALSE,    optimizer_use_netio => FALSE,    optimizer_use_parallel => FALSE,    optimizer_use_partition => FALSE,    optimizer_use_replica => FALSE,    optimizer_use_cluster => FALSE,    optimizer_use_cache => FALSE,    optimizer_use_buffer => FALSE,    optimizer_use_temp => FALSE,    optimizer_use_swap => FALSE,    optimizer_use_diskio => FALSE,    optimizer_use_netio => FALSE,    optimizer_use_parallel => FALSE,    optimizer_use_partition => FALSE,    optimizer_use_replica => FALSE,    optimizer_use_cluster => FALSE,    optimizer_use_cache => FALSE,    optimizer_use_buffer => FALSE,    optimizer_use_temp => FALSE,    optimizer_use_swap => FALSE,    optimizer_use_diskio => FALSE,    optimizer_use_netio => FALSE,    optimizer_use_parallel => FALSE,    optimizer_use_partition => FALSE,    optimizer_use_replica => FALSE,    optimizer_use_cluster => FALSE,    optimizer_use_cache => FALSE,    optimizer_use_buffer => FALSE,    optimizer_use_temp => FALSE,    optimizer_use_swap => FALSE,    optimizer_use_diskio => FALSE,    optimizer_use_netio => FALSE,    optimizer_use_parallel => FALSE,    optimizer_use_partition => FALSE,    optimizer_use_replica => FALSE,    optimizer_use_cluster => FALSE,    optimizer_use_cache => FALSE,    optimizer_use_buffer => FALSE,    optimizer_use_temp => FALSE,    optimizer_use_swap => FALSE,    optimizer_use_diskio => FALSE,    optimizer_use_netio => FALSE,    optimizer_use_parallel => FALSE,    optimizer_use_partition => FALSE,    optimizer_use_replica => FALSE,    optimizer_use_cluster => FALSE,    optimizer_use_cache => FALSE,    optimizer_use_buffer => FALSE,    optimizer_use_temp => FALSE,    optimizer_use_swap => FALSE,    optimizer_use_diskio => FALSE,    optimizer_use_netio => FALSE,    optimizer_use_parallel => FALSE,    optimizer_use_partition => FALSE,    optimizer_use_replica => FALSE,    optimizer_use_cluster => FALSE,    optimizer_use_cache => FALSE,    optimizer_use_buffer => FALSE,    optimizer_use_temp => FALSE,    optimizer_use_swap => FALSE,    optimizer_use_diskio => FALSE,    optimizer_use_netio => FALSE,    optimizer_use_parallel => FALSE,    optimizer_use_partition => FALSE,    optimizer_use_replica => FALSE,    optimizer_use_cluster => FALSE,    optimizer_use_cache => FALSE,    optimizer_use_buffer => FALSE,    optimizer_use_temp => FALSE,    optimizer_use_swap => FALSE,    optimizer_use_diskio => FALSE,    optimizer_use_netio => FALSE,    optimizer_use_parallel => FALSE,    optimizer_use_partition => FALSE,    optimizer_use_replica => FALSE,    optimizer_use_cluster => FALSE,    optimizer_use_cache => FALSE,    optimizer_use_buffer => FALSE,    optimizer_use_temp => FALSE,    optimizer_use_swap => FALSE,    optimizer_use_diskio => FALSE,    optimizer_use_netio => FALSE,    optimizer_use_parallel => FALSE,    optimizer_use_partition => FALSE,    optimizer_use_replica => FALSE,    optimizer_use_cluster => FALSE,    optimizer_use_cache => FALSE,    optimizer_use_buffer => FALSE,    optimizer_use_temp => FALSE,    optimizer_use_swap => FALSE,    optimizer_use_diskio => FALSE,    optimizer_use_netio => FALSE,    optimizer_use_parallel => FALSE,    optimizer_use_partition => FALSE,    optimizer_use_replica => FALSE,    optimizer_use_cluster => FALSE,    optimizer_use_cache => FALSE,    optimizer_use_buffer => FALSE,    optimizer_use_temp => FALSE,    optimizer_use_swap => FALSE,    optimizer_use_diskio => FALSE,    optimizer_use_netio => FALSE,    optimizer_use_parallel => FALSE,    optimizer_use_partition => FALSE,    optimizer_use_replica => FALSE,    optimizer_use_cluster => FALSE,    optimizer_use_cache => FALSE,    optimizer_use_buffer => FALSE,    optimizer_use_temp => FALSE,    optimizer_use_swap => FALSE,    optimizer_use_diskio => FALSE,    optimizer_use_netio => FALSE,    optimizer_use_parallel => FALSE,    optimizer_use_partition => FALSE,    optimizer_use_replica => FALSE,    optimizer_use_cluster => FALSE,    optimizer_use_cache => FALSE,    optimizer_use_buffer => FALSE,    optimizer_use_temp => FALSE,    optimizer_use_swap => FALSE,    optimizer_use_diskio => FALSE,    optimizer_use_netio => FALSE,    optimizer_use_parallel => FALSE,    optimizer_use_partition => FALSE,    optimizer_use_replica => FALSE,    optimizer_use_cluster => FALSE,    optimizer_use_cache => FALSE,    optimizer_use_buffer => FALSE,    optimizer_use_temp => FALSE,    optimizer_use_swap => FALSE,    optimizer_use_diskio => FALSE,    optimizer_use_netio => FALSE,    optimizer_use_parallel => FALSE,    optimizer_use_partition => FALSE,    optimizer_use_replica => FALSE,    optimizer_use_cluster => FALSE,    optimizer_use_cache => FALSE,    optimizer_use_buffer => FALSE,    optimizer_use_temp => FALSE,    optimizer_use_swap => FALSE,    optimizer_use_diskio => FALSE,    optimizer_use_netio => FALSE,    optimizer_use_parallel => FALSE,    optimizer_use_partition => FALSE,    optimizer_use_replica => FALSE,    optimizer_use_cluster => FALSE,    optimizer_use_cache => FALSE,    optimizer_use_buffer => FALSE,    optimizer_use_temp => FALSE,    optimizer_use_swap => FALSE,    optimizer_use_diskio => FALSE,    optimizer_use_netio => FALSE,    optimizer_use_parallel => FALSE,    optimizer_use_partition => FALSE,    optimizer_use_replica => FALSE,    optimizer_use_cluster => FALSE,    optimizer_use_cache => FALSE,    optimizer_use_buffer => FALSE,    optimizer_use_temp => FALSE,    optimizer_use_swap => FALSE,    optimizer_use_diskio => FALSE,    optimizer_use_netio => FALSE,    optimizer_use_parallel => FALSE,    optimizer_use_partition => FALSE,    optimizer_use_replica => FALSE,    optimizer_use_cluster => FALSE,    optimizer_use_cache => FALSE,    optimizer_use_buffer => FALSE,    optimizer_use_temp => FALSE,    optimizer_use_swap => FALSE,    optimizer_use_diskio => FALSE,    optimizer_use_netio => FALSE,    optimizer_use_parallel => FALSE,    optimizer_use_partition => FALSE,    optimizer_use_replica => FALSE,    optimizer_use_cluster => FALSE,    optimizer_use_cache => FALSE,    optimizer_use_buffer => FALSE,    optimizer_use_temp => FALSE,    optimizer_use_swap => FALSE,    optimizer_use_diskio => FALSE,    optimizer_use_netio => FALSE,    optimizer_use_parallel => FALSE,    optimizer_use_partition => FALSE,    optimizer_use_replica => FALSE,    optimizer_use_cluster => FALSE,    optimizer_use_cache => FALSE,    optimizer_use_buffer => FALSE,    optimizer_use_temp => FALSE,    optimizer_use_swap => FALSE,    optimizer_use_diskio => FALSE,    optimizer_use_netio => FALSE,    optimizer_use_parallel => FALSE,    optimizer_use_partition => FALSE,    optimizer_use_replica => FALSE,    optimizer_use_cluster => FALSE,    optimizer_use_cache => FALSE,    optimizer_use_buffer => FALSE,    optimizer_use_temp => FALSE,    optimizer_use_swap => FALSE,    optimizer_use_diskio => FALSE,    optimizer_use_netio => FALSE,    optimizer_use_parallel => FALSE,    optimizer_use_partition => FALSE,    optimizer_use_replica => FALSE,    optimizer_use_cluster => FALSE,    optimizer_use_cache => FALSE,    optimizer_use_buffer => FALSE,    optimizer_use_temp => FALSE,    optimizer_use_swap => FALSE,    optimizer_use_diskio => FALSE,    optimizer_use_netio => FALSE,    optimizer_use_parallel => FALSE,    optimizer_use_partition => FALSE,    optimizer_use_replica => FALSE,    optimizer_use_cluster => FALSE,    optimizer_use_cache => FALSE,    optimizer_use_buffer => FALSE,    optimizer_use_temp => FALSE,    optimizer_use_swap => FALSE,    optimizer_use_diskio => FALSE,    optimizer_use_netio => FALSE,    optimizer_use_parallel => FALSE,    optimizer_use_partition => FALSE,    optimizer_use_replica => FALSE,    optimizer_use_cluster => FALSE,    optimizer_use_cache => FALSE,    optimizer_use_buffer => FALSE,    optimizer_use_temp => FALSE,    optimizer_use_swap => FALSE,    optimizer_use_diskio => FALSE,    optimizer_use_netio => FALSE,    optimizer_use_parallel => FALSE,    optimizer_use_partition => FALSE,    optimizer_use_replica => FALSE,    optimizer_use_cluster => FALSE,    optimizer_use_cache => FALSE,    optimizer_use_buffer => FALSE,    optimizer_use_temp => FALSE,    optimizer_use_swap => FALSE,    optimizer_use_diskio => FALSE,    optimizer_use_netio => FALSE,    optimizer_use_parallel => FALSE,    optimizer_use_partition => FALSE,    optimizer_use_replica => FALSE,    optimizer_use_cluster => FALSE,    optimizer_use_cache => FALSE,    optimizer_use_buffer => FALSE,    optimizer_use_temp => FALSE,    optimizer_use_swap => FALSE,    optimizer_use_diskio => FALSE,    optimizer_use_netio => FALSE,    optimizer_use_parallel => FALSE,    optimizer_use_partition => FALSE,    optimizer_use_replica => FALSE,    optimizer_use_cluster => FALSE,    optimizer_use_cache => FALSE,    optimizer_use_buffer => FALSE,    optimizer_use_temp => FALSE,    optimizer_use_swap => FALSE,    optimizer_use_diskio => FALSE,    optimizer_use_netio => FALSE,    optimizer_use_parallel => FALSE,    optimizer_use_partition => FALSE,    optimizer_use_replica => FALSE,    optimizer_use_cluster => FALSE,    optimizer_use_cache => FALSE,    optimizer_use_buffer => FALSE,    optimizer_use_temp => FALSE,    optimizer_use_swap => FALSE,    optimizer_use_diskio => FALSE,    optimizer_use_netio => FALSE,    optimizer_use_parallel => FALSE,    optimizer_use_partition => FALSE,    optimizer_use_replica => FALSE,    optimizer_use_cluster => FALSE,    optimizer_use_cache => FALSE,    optimizer_use_buffer => FALSE,    optimizer_use_temp => FALSE,    optimizer_use_swap => FALSE,    optimizer_use_diskio => FALSE,    optimizer_use_netio => FALSE,    optimizer_use_parallel => FALSE,    optimizer_use_partition => FALSE,    optimizer_use_replica => FALSE,    optimizer_use_cluster => FALSE,    optimizer_use_cache => FALSE,    optimizer_use_buffer => FALSE,    optimizer_use_temp => FALSE,    optimizer_use_swap => FALSE,    optimizer_use_diskio => FALSE,    optimizer_use_netio => FALSE,    optimizer_use_parallel => FALSE,    optimizer_use_partition => FALSE,    optimizer_use_replica => FALSE,    optimizer_use_cluster => FALSE,    optimizer_use_cache => FALSE,    optimizer_use_buffer => FALSE,    optimizer_use_temp => FALSE,    optimizer_use_swap => FALSE,    optimizer_use_diskio => FALSE,    optimizer_use_netio => FALSE,    optimizer_use_parallel => FALSE,    optimizer_use_partition => FALSE,    optimizer_use_replica => FALSE,    optimizer_use_cluster => FALSE,    optimizer_use_cache => FALSE,    optimizer_use_buffer => FALSE,    optimizer_use_temp => FALSE,    optimizer_use_swap => FALSE,    optimizer_use_diskio => FALSE,    optimizer_use_netio => FALSE,    optimizer_use_parallel => FALSE,    optimizer_use_partition => FALSE,    optimizer_use_replica => FALSE,    optimizer_use_cluster => FALSE,    optimizer_use_cache => FALSE,    optimizer_use_buffer => FALSE,    optimizer_use_temp => FALSE,    optimizer_use_swap => FALSE,    optimizer_use_diskio => FALSE,    optimizer_use_netio => FALSE,    optimizer_use_parallel => FALSE,    optimizer_use_partition => FALSE,    optimizer_use_replica => FALSE,    optimizer_use_cluster => FALSE,    optimizer_use_cache => FALSE,    optimizer_use_buffer => FALSE,    optimizer_use_temp => FALSE,    optimizer_use_swap => FALSE,    optimizer_use_diskio => FALSE,    optimizer_use_netio => FALSE,    optimizer_use_parallel => FALSE,    optimizer_use_partition => FALSE,    optimizer_use_replica => FALSE,    optimizer_use_cluster => FALSE,    optimizer_use_cache => FALSE,    optimizer_use_buffer => FALSE,    optimizer_use_temp => FALSE,    optimizer_use_swap => FALSE,    optimizer_use_diskio => FALSE,    optimizer_use_netio => FALSE,    optimizer_use_parallel => FALSE,    optimizer_use_partition => FALSE,    optimizer_use_replica => FALSE,    optimizer_use_cluster => FALSE,    optimizer_use_cache => FALSE,    optimizer_use_buffer => FALSE,    optimizer_use_temp => FALSE,    optimizer_use_swap => FALSE,    optimizer_use_diskio => FALSE,    optimizer_use_netio => FALSE,    optimizer_use_parallel => FALSE,    optimizer_use_partition => FALSE,    optimizer_use_replica => FALSE,    optimizer_use_cluster => FALSE,    optimizer_use_cache => FALSE,    optimizer_use_buffer => FALSE,    optimizer_use_temp => FALSE,    optimizer_use_swap => FALSE,    optimizer_use_diskio => FALSE,    optimizer_use_netio => FALSE,    optimizer_use_parallel => FALSE,    optimizer_use_partition => FALSE,    optimizer_use_replica => FALSE,    optimizer_use_cluster => FALSE,    optimizer_use_cache => FALSE,    optimizer_use_buffer => FALSE,    optimizer_use_temp => FALSE,    optimizer_use_swap => FALSE,    optimizer_use_diskio => FALSE,    optimizer_use_netio => FALSE,    optimizer_use_parallel => FALSE,    optimizer_use_partition => FALSE,    optimizer_use_replica => FALSE,    optimizer_use_cluster => FALSE,    optimizer_use_cache => FALSE,    optimizer_use_buffer => FALSE,    optimizer_use_temp => FALSE,    optimizer_use_swap => FALSE,    optimizer_use_diskio => FALSE,    optimizer_use_netio => FALSE,    optimizer_use_parallel => FALSE,    optimizer_use_partition => FALSE,    optimizer_use_replica => FALSE,    optimizer_use_cluster => FALSE,    optimizer_use_cache => FALSE,    optimizer_use_buffer => FALSE,    optimizer_use_temp => FALSE,    optimizer_use_swap => FALSE,    optimizer_use_diskio => FALSE,    optimizer_use_netio => FALSE,    optimizer_use_parallel => FALSE,    optimizer_use_partition => FALSE,    optimizer_use_replica => FALSE,    optimizer_use_cluster => FALSE,    optimizer_use_cache => FALSE,    optimizer_use_buffer => FALSE,    optimizer_use_temp => FALSE,    optimizer_use_swap => FALSE,    optimizer_use_diskio => FALSE,    optimizer_use_netio => FALSE,    optimizer_use_parallel => FALSE,    optimizer_use_partition => FALSE,    optimizer_use_replica => FALSE,    optimizer_use_cluster => FALSE,    optimizer_use_cache => FALSE,    optimizer_use_buffer => FALSE,    optimizer_use_temp => FALSE,    optimizer_use_swap => FALSE,    optimizer_use_diskio => FALSE,    optimizer_use_netio => FALSE,    optimizer_use_parallel => FALSE,    optimizer_use_partition => FALSE,    optimizer_use_replica => FALSE,    optimizer_use_cluster => FALSE,    optimizer_use_cache => FALSE,    optimizer_use_buffer => FALSE,    optimizer_use_temp => FALSE,    optimizer_use_swap => FALSE,    optimizer_use_diskio => FALSE,    optimizer_use_netio => FALSE,    optimizer_use_parallel => FALSE,    optimizer_use_partition => FALSE,    optimizer_use_replica => FALSE,    optimizer_use_cluster => FALSE,    optimizer_use_cache => FALSE,    optimizer_use_buffer => FALSE,    optimizer_use_temp => FALSE,    optimizer_use_swap => FALSE,    optimizer_use_diskio => FALSE,    optimizer_use_netio => FALSE,    optimizer_use_parallel => FALSE,    optimizer_use_partition => FALSE,    optimizer_use_replica => FALSE,    optimizer_use_cluster => FALSE,    optimizer_use_cache => FALSE,    optimizer_use_buffer => FALSE,    optimizer_use_temp => FALSE,    optimizer_use_swap => FALSE,    optimizer_use_diskio => FALSE,    optimizer_use_netio => FALSE,    optimizer_use_parallel => FALSE,    optimizer_use_partition => FALSE,    optimizer_use_replica => FALSE,    optimizer_use_cluster => FALSE,    optimizer_use_cache => FALSE,    optimizer_use_buffer => FALSE,    optimizer_use_temp => FALSE,    optimizer_use_swap => FALSE,    optimizer_use_diskio => FALSE,    optimizer_use_netio => FALSE,    optimizer_use_parallel => FALSE,    optimizer_use_partition => FALSE,    optimizer_use_replica => FALSE,    optimizer_use_cluster => FALSE,    optimizer_use_cache => FALSE,    optimizer_use_buffer => FALSE,    optimizer_use_temp => FALSE,    optimizer_use_swap => FALSE,    optimizer_use_diskio => FALSE,    optimizer_use_netio => FALSE,    optimizer_use_parallel => FALSE,    optimizer_use_partition => FALSE,    optimizer_use_replica => FALSE,    optimizer_use_cluster => FALSE,    optimizer_use_cache => FALSE,    optimizer_use_buffer => FALSE,    optimizer_use_temp => FALSE,    optimizer_use_swap => FALSE,    optimizer_use_diskio => FALSE,    optimizer_use_netio => FALSE,    optimizer_use_parallel => FALSE,    optimizer_use_partition => FALSE,    optimizer_use_replica => FALSE,    optimizer_use_cluster => FALSE,    optimizer_use_cache => FALSE,    optimizer_use_buffer => FALSE,    optimizer_use_temp => FALSE,    optimizer_use_swap => FALSE,    optimizer_use_diskio => FALSE,    optimizer_use_netio => FALSE,    optimizer_use_parallel => FALSE,    optimizer_use_partition => FALSE,    optimizer_use_replica => FALSE,    optimizer_use_cluster => FALSE,    optimizer_use_cache => FALSE,    optimizer_use_buffer => FALSE,    optimizer_use_temp => FALSE,    optimizer_use_swap => FALSE,    optimizer_use_diskio => FALSE,    optimizer_use_netio => FALSE,    optimizer_use_parallel => FALSE,    optimizer_use_partition => FALSE,    optimizer_use_replica => FALSE,    optimizer_use_cluster => FALSE,    optimizer_use_cache => FALSE,    optimizer_use_buffer => FALSE,    optimizer_use_temp => FALSE,    optimizer_use_swap => FALSE,    optimizer_use_diskio => FALSE,    optimizer_use_netio => FALSE,    optimizer_use_parallel => FALSE,    optimizer_use_partition => FALSE,    optimizer_use_replica => FALSE,    optimizer_use_cluster => FALSE,    optimizer_use_cache => FALSE,    optimizer_use_buffer => FALSE,    optimizer_use_temp => FALSE,    optimizer_use_swap => FALSE,    optimizer_use_diskio => FALSE,    optimizer_use_netio => FALSE,    optimizer_use_parallel => FALSE,    optimizer_use_partition => FALSE,    optimizer_use_replica => FALSE,    optimizer_use_cluster => FALSE,    optimizer_use_cache => FALSE,    optimizer_use_buffer => FALSE,    optimizer_use_temp => FALSE,    optimizer_use_swap => FALSE,    optimizer_use_diskio => FALSE,    optimizer_use_netio => FALSE,    optimizer_use_parallel => FALSE,    optimizer_use_partition => FALSE,    optimizer_use_replica => FALSE,    optimizer_use_cluster => FALSE,    optimizer_use_cache => FALSE,    optimizer_use_buffer => FALSE,    optimizer_use_temp => FALSE,    optimizer_use_swap => FALSE,    optimizer_use_diskio => FALSE,    optimizer_use_netio => FALSE,    optimizer_use_parallel => FALSE,    optimizer_use_partition => FALSE,    optimizer_use_replica => FALSE,    optimizer_use_cluster => FALSE,    optimizer_use_cache => FALSE,    optimizer_use_buffer => FALSE,    optimizer_use_temp => FALSE,    optimizer_use_swap => FALSE,    optimizer_use_diskio => FALSE,    optimizer_use_netio => FALSE,    optimizer_use_parallel => FALSE,    optimizer_use_partition => FALSE,    optimizer_use_replica => FALSE,    optimizer_use_cluster => FALSE,    optimizer_use_cache => FALSE,    optimizer_use_buffer => FALSE,    optimizer_use_temp => FALSE,    optimizer_use_swap => FALSE,    optimizer_use_diskio => FALSE,    optimizer_use_netio => FALSE,    optimizer_use_parallel => FALSE,    optimizer_use_partition => FALSE,    optimizer_use_replica => FALSE,    optimizer_use_cluster => FALSE,    optimizer_use_cache => FALSE,    optimizer_use_buffer => FALSE,    optimizer_use_temp => FALSE,    optimizer_use_swap => FALSE,    optimizer_use_diskio => FALSE,    optimizer_use_netio => FALSE