在现代企业中，数据中台、数字孪生和数字可视化技术的应用越来越广泛，而这些技术的核心离不开高效的数据库性能。在Oracle数据库中，SQL语句的执行效率直接影响到整个系统的性能表现。为了优化SQL性能，Oracle提供了一种强大的工具——Oracle SQL Profile。本文将深入探讨Oracle SQL Profile的应用场景、使用方法以及如何通过它来提升SQL性能。

什么是Oracle SQL Profile？

Oracle SQL Profile是一种用于优化SQL语句执行性能的工具。它通过分析SQL语句的执行计划、访问路径和资源消耗，为数据库优化器（Optimizer）提供额外的指导信息，从而帮助优化器生成更高效的执行计划。

简单来说，SQL Profile可以看作是数据库优化器的“顾问”，它通过收集和分析SQL语句的执行信息，帮助优化器做出更明智的决策，从而提升SQL语句的执行效率。

Oracle SQL Profile的作用

1. 优化执行计划SQL Profile可以帮助优化器生成更优的执行计划。例如，当优化器无法找到最优的访问路径时，SQL Profile可以通过提供额外的统计信息，帮助优化器选择更高效的执行路径。

2. 减少资源消耗通过优化SQL语句的执行效率，SQL Profile可以减少CPU、内存和磁盘I/O等资源的消耗，从而降低数据库的负载。

3. 提升查询响应时间对于复杂的SQL查询，SQL Profile可以显著缩短执行时间，提升系统的响应速度。

4. 支持数据库迁移和升级在数据库迁移或升级过程中，SQL Profile可以帮助确保SQL语句在新环境中仍然高效执行。

如何使用Oracle SQL Profile？

使用Oracle SQL Profile需要遵循以下步骤：

1. 收集SQL性能数据

首先，需要收集SQL语句的执行信息。可以通过以下几种方式收集数据：

• 使用DBMS_PROFILER包Oracle提供了一个名为DBMS_PROFILER的包，可以用来收集SQL语句的执行时间、CPU使用情况和I/O统计信息。

• 使用STATSPACK报告STATSPACK是一个轻量级的性能监控工具，可以生成详细的性能报告，包括SQL语句的执行统计信息。

• 使用AWR（Automatic Workload Repository）报告AWR报告提供了详细的SQL性能分析，包括SQL语句的执行计划和资源消耗情况。

2. 分析SQL执行计划

在收集到SQL性能数据后，需要分析SQL语句的执行计划。可以通过以下命令查看执行计划：

EXPLAIN PLAN FOR  SELECT /* Your SQL Statement Here */;

执行上述命令后，可以通过以下查询查看执行计划：

SELECT * FROM TABLE(DBMS_XPLAN.DISPLAY());

3. 创建SQL Profile

在分析完SQL执行计划后，可以使用DBMS_SQLTUNE包创建SQL Profile。以下是创建SQL Profile的示例代码：

DECLARE  l_sql_id   VARCHAR2(100) := 'SQL_ID'; -- 替换为实际的SQL ID  l_profile  VARCHAR2(100) := 'PROFILE_NAME'; -- 替换为自定义的Profile名称BEGIN  DBMS_SQLTUNE.CREATE_SQL_PROFILE(    sql_id => l_sql_id,    profile => l_profile,    description => 'Profile for SQL_ID ' || l_sql_id,    active => 'YES',    apply_to_sql_id => l_sql_id,    plan_hash_value => NULL,    optimizer_mode => 'ALL_ROWS',    optimizer_index_cost_adj => 1,    optimizer_index_caching => 0,    optimizer_use_invisible_index => 'NO',    optimizer_adaptive_mtics => 1000,    optimizer_max_mtics => 10000,    optimizer_parallelism => 0,    optimizer_plan_hash => NULL,    optimizer_statistics => 'ALL',    optimizer_stats => 'STANDARD',    optimizer_table_stats => 'STANDARD',    optimizer_column_stats => 'STANDARD',    optimizer_histograms => 'STANDARD',    optimizer_cost => 'STANDARD',    optimizer_time => 'STANDARD',    optimizer_cardinality => 'STANDARD',    optimizer_selectivity => 'STANDARD',    optimizer_group_by => 'STANDARD',    optimizer_hints => 'STANDARD',    optimizer_transformation => 'STANDARD',    optimizer_subquery => 'STANDARD',    optimizer_windowing => 'STANDARD',    optimizer_sort => 'STANDARD',    optimizer_hash => 'STANDARD',    optimizer_join => 'STANDARD',    optimizer_partitioning => 'STANDARD',    optimizer_cost_based_TBS => 'STANDARD',    optimizer_feedback => 'STANDARD',    optimizer_statistics_level => 'ALL',    optimizer_query_rewrite => 'STANDARD',    optimizer_result_cache => 'STANDARD',    optimizer_inmemory => 'STANDARD',    optimizer_inmemory_stats => 'STANDARD',    optimizer_inmemory_join => 'STANDARD',    optimizer_inmemory_sort => 'STANDARD',    optimizer_inmemory_hash => 'STANDARD',    optimizer_inmemory_group_by => 'STANDARD',    optimizer_inmemory_windowing => 'STANDARD',    optimizer_inmemory_aggregation => 'STANDARD',    optimizer_inmemory_pivot => 'STANDARD',    optimizer_inmemory_analytics => 'STANDARD',    optimizer_inmemory_cube => 'STANDARD',    optimizer_inmemory_rollup => 'STANDARD',    optimizer_inmemory_pdb => 'STANDARD',    optimizer_inmemory_dml => 'STANDARD',    optimizer_inmemory_ddl => 'STANDARD',    optimizer_inmemory_query_rewrite => 'STANDARD',    optimizer_inmemory_feedback => 'STANDARD',    optimizer_inmemory_statistics => 'STANDARD',    optimizer_inmemory_histograms => 'STANDARD',    optimizer_inmemory_cost => 'STANDARD',    optimizer_inmemory_time => 'STANDARD',    optimizer_inmemory_cardinality => 'STANDARD',    optimizer_inmemory_selectivity => 'STANDARD',    optimizer_inmemory_group_by => 'STANDARD',    optimizer_inmemory_windowing => 'STANDARD',    optimizer_inmemory_aggregation => 'STANDARD',    optimizer_inmemory_pivot => 'STANDARD',    optimizer_inmemory_analytics => 'STANDARD',    optimizer_inmemory_cube => 'STANDARD',    optimizer_inmemory_rollup => 'STANDARD',    optimizer_inmemory_pdb => 'STANDARD',    optimizer_inmemory_dml => 'STANDARD',    optimizer_inmemory_ddl => 'STANDARD',    optimizer_inmemory_query_rewrite => 'STANDARD',    optimizer_inmemory_feedback => 'STANDARD',    optimizer_inmemory_statistics => 'STANDARD',    optimizer_inmemory_histograms => 'STANDARD',    optimizer_inmemory_cost => 'STANDARD',    optimizer_inmemory_time => 'STANDARD',    optimizer_inmemory_cardinality => 'STANDARD',    optimizer_inmemory_selectivity => 'STANDARD',    optimizer_inmemory_group_by => 'STANDARD',    optimizer_inmemory_windowing => 'STANDARD',    optimizer_inmemory_aggregation => 'STANDARD',    optimizer_inmemory_pivot => 'STANDARD',    optimizer_inmemory_analytics => 'STANDARD',    optimizer_inmemory_cube => 'STANDARD',    optimizer_inmemory_rollup => 'STANDARD',    optimizer_inmemory_pdb => 'STANDARD',    optimizer_inmemory_dml => 'STANDARD',    optimizer_inmemory_ddl => 'STANDARD',    optimizer_inmemory_query_rewrite => 'STANDARD',    optimizer_inmemory_feedback => 'STANDARD',    optimizer_inmemory_statistics => 'STANDARD',    optimizer_inmemory_histograms => 'STANDARD',    optimizer_inmemory_cost => 'STANDARD',    optimizer_inmemory_time => 'STANDARD',    optimizer_inmemory_cardinality => 'STANDARD',    optimizer_inmemory_selectivity => 'STANDARD',    optimizer_inmemory_group_by => 'STANDARD',    optimizer_inmemory_windowing => 'STANDARD',    optimizer_inmemory_aggregation => 'STANDARD',    optimizer_inmemory_pivot => 'STANDARD',    optimizer_inmemory_analytics => 'STANDARD',    optimizer_inmemory_cube => 'STANDARD',    optimizer_inmemory_rollup => 'STANDARD',    optimizer_inmemory_pdb => 'STANDARD',    optimizer_inmemory_dml => 'STANDARD',    optimizer_inmemory_ddl => 'STANDARD',    optimizer_inmemory_query_rewrite => 'STANDARD',    optimizer_inmemory_feedback => 'STANDARD',    optimizer_inmemory_statistics => 'STANDARD',    optimizer_inmemory_histograms => 'STANDARD',    optimizer_inmemory_cost => 'STANDARD',    optimizer_inmemory_time => 'STANDARD',    optimizer_inmemory_cardinality => 'STANDARD',    optimizer_inmemory_selectivity => 'STANDARD',    optimizer_inmemory_group_by => 'STANDARD',    optimizer_inmemory_windowing => 'STANDARD',    optimizer_inmemory_aggregation => 'STANDARD',    optimizer_inmemory_pivot => 'STANDARD',    optimizer_inmemory_analytics => 'STANDARD',    optimizer_inmemory_cube => 'STANDARD',    optimizer_inmemory_rollup => 'STANDARD',    optimizer_inmemory_pdb => 'STANDARD',    optimizer_inmemory_dml => 'STANDARD',    optimizer_inmemory_ddl => 'STANDARD',    optimizer_inmemory_query_rewrite => 'STANDARD',    optimizer_inmemory_feedback => 'STANDARD',    optimizer_inmemory_statistics => 'STANDARD',    optimizer_inmemory_histograms => 'STANDARD',    optimizer_inmemory_cost => 'STANDARD',    optimizer_inmemory_time => 'STANDARD',    optimizer_inmemory_cardinality => 'STANDARD',    optimizer_inmemory_selectivity => 'STANDARD',    optimizer_inmemory_group_by => 'STANDARD',    optimizer_inmemory_windowing => 'STANDARD',    optimizer_inmemory_aggregation => 'STANDARD',    optimizer_inmemory_pivot => 'STANDARD',    optimizer_inmemory_analytics => 'STANDARD',    optimizer_inmemory_cube => 'STANDARD',    optimizer_inmemory_rollup => 'STANDARD',    optimizer_inmemory_pdb => 'STANDARD',    optimizer_inmemory_dml => 'STANDARD',    optimizer_inmemory_ddl => 'STANDARD',    optimizer_inmemory_query_rewrite => 'STANDARD',    optimizer_inmemory_feedback => 'STANDARD',    optimizer_inmemory_statistics => 'STANDARD',    optimizer_inmemory_histograms => 'STANDARD',    optimizer_inmemory_cost => 'STANDARD',    optimizer_inmemory_time => 'STANDARD',    optimizer_inmemory_cardinality => 'STANDARD',    optimizer_inmemory_selectivity => 'STANDARD',    optimizer_inmemory_group_by => 'STANDARD',    optimizer_inmemory_windowing => 'STANDARD',    optimizer_inmemory_aggregation => 'STANDARD',    optimizer_inmemory_pivot => 'STANDARD',    optimizer_inmemory_analytics => 'STANDARD',    optimizer_inmemory_cube => 'STANDARD',    optimizer_inmemory_rollup => 'STANDARD',    optimizer_inmemory_pdb => 'STANDARD',    optimizer_inmemory_dml => 'STANDARD',    optimizer_inmemory_ddl => 'STANDARD',    optimizer_inmemory_query_rewrite => 'STANDARD',    optimizer_inmemory_feedback => 'STANDARD',    optimizer_inmemory_statistics => 'STANDARD',    optimizer_inmemory_histograms => 'STANDARD',    optimizer_inmemory_cost => 'STANDARD',    optimizer_inmemory_time => 'STANDARD',    optimizer_inmemory_cardinality => 'STANDARD',    optimizer_inmemory_selectivity => 'STANDARD',    optimizer_inmemory_group_by => 'STANDARD',    optimizer_inmemory_windowing => 'STANDARD',    optimizer_inmemory_aggregation => 'STANDARD',    optimizer_inmemory_pivot => 'STANDARD',    optimizer_inmemory_analytics => 'STANDARD',    optimizer_inmemory_cube => 'STANDARD',    optimizer_inmemory_rollup => 'STANDARD',    optimizer_inmemory_pdb => 'STANDARD',    optimizer_inmemory_dml => 'STANDARD',    optimizer_inmemory_ddl => 'STANDARD',    optimizer_inmemory_query_rewrite => 'STANDARD',    optimizer_inmemory_feedback => 'STANDARD',    optimizer_inmemory_statistics => 'STANDARD',    optimizer_inmemory_histograms => 'STANDARD',    optimizer_inmemory_cost => 'STANDARD',    optimizer_inmemory_time => 'STANDARD',    optimizer_inmemory_cardinality => 'STANDARD',    optimizer_inmemory_selectivity => 'STANDARD',    optimizer_inmemory_group_by => 'STANDARD',    optimizer_inmemory_windowing => 'STANDARD',    optimizer_inmemory_aggregation => 'STANDARD',    optimizer_inmemory_pivot => 'STANDARD',    optimizer_inmemory_analytics => 'STANDARD',    optimizer_inmemory_cube => 'STANDARD',    optimizer_inmemory_rollup => 'STANDARD',    optimizer_inmemory_pdb => 'STANDARD',    optimizer_inmemory_dml => 'STANDARD',    optimizer_inmemory_ddl => 'STANDARD',    optimizer_inmemory_query_rewrite => 'STANDARD',    optimizer_inmemory_feedback => 'STANDARD',    optimizer_inmemory_statistics => 'STANDARD',    optimizer_inmemory_histograms => 'STANDARD',    optimizer_inmemory_cost => 'STANDARD',    optimizer_inmemory_time => 'STANDARD',    optimizer_inmemory_cardinality => 'STANDARD',    optimizer_inmemory_selectivity => 'STANDARD',    optimizer_inmemory_group_by => 'STANDARD',    optimizer_inmemory_windowing => 'STANDARD',    optimizer_inmemory_aggregation => 'STANDARD',    optimizer_inmemory_pivot => 'STANDARD',    optimizer_inmemory_analytics => 'STANDARD',    optimizer_inmemory_cube => 'STANDARD',    optimizer_inmemory_rollup => 'STANDARD',    optimizer_inmemory_pdb => 'STANDARD',    optimizer_inmemory_dml => 'STANDARD',    optimizer_inmemory_ddl => 'STANDARD',    optimizer_inmemory_query_rewrite => 'STANDARD',    optimizer_inmemory_feedback => 'STANDARD',    optimizer_inmemory_statistics => 'STANDARD',    optimizer_inmemory_histograms => 'STANDARD',    optimizer_inmemory_cost => 'STANDARD',    optimizer_inmemory_time => 'STANDARD',    optimizer_inmemory_cardinality => 'STANDARD',    optimizer_inmemory_selectivity => 'STANDARD',    optimizer_inmemory_group_by => 'STANDARD',    optimizer_inmemory_windowing => 'STANDARD',    optimizer_inmemory_aggregation => 'STANDARD',    optimizer_inmemory_pivot => 'STANDARD',    optimizer_inmemory_analytics => 'STANDARD',    optimizer_inmemory_cube => 'STANDARD',    optimizer_inmemory_rollup => 'STANDARD',    optimizer_inmemory_pdb => 'STANDARD',    optimizer_inmemory_dml => 'STANDARD',    optimizer_inmemory_ddl => 'STANDARD',    optimizer_inmemory_query_rewrite => 'STANDARD',    optimizer_inmemory_feedback => 'STANDARD',    optimizer_inmemory_statistics => 'STANDARD',    optimizer_inmemory_histograms => 'STANDARD',    optimizer_inmemory_cost => 'STANDARD',    optimizer_inmemory_time => 'STANDARD',    optimizer_inmemory_cardinality => 'STANDARD',    optimizer_inmemory_selectivity => 'STANDARD',    optimizer_inmemory_group_by => 'STANDARD',    optimizer_inmemory_windowing => 'STANDARD',    optimizer_inmemory_aggregation => 'STANDARD',    optimizer_inmemory_pivot => 'STANDARD',    optimizer_inmemory_analytics => 'STANDARD',    optimizer_inmemory_cube => 'STANDARD',    optimizer_inmemory_rollup => 'STANDARD',    optimizer_inmemory_pdb => 'STANDARD',    optimizer_inmemory_dml => 'STANDARD',    optimizer_inmemory_ddl => 'STANDARD',    optimizer_inmemory_query_rewrite => 'STANDARD',    optimizer_inmemory_feedback => 'STANDARD',    optimizer_inmemory_statistics => 'STANDARD',    optimizer_inmemory_histograms => 'STANDARD',    optimizer_inmemory_cost => 'STANDARD',    optimizer_inmemory_time => 'STANDARD',    optimizer_inmemory_cardinality => 'STANDARD',    optimizer_inmemory_selectivity => 'STANDARD',    optimizer_inmemory_group_by => 'STANDARD',    optimizer_inmemory_windowing => 'STANDARD',    optimizer_inmemory_aggregation => 'STANDARD',    optimizer_inmemory_pivot => 'STANDARD',    optimizer_inmemory_analytics => 'STANDARD',    optimizer_inmemory_cube => 'STANDARD',    optimizer_inmemory_rollup => 'STANDARD',    optimizer_inmemory_pdb => 'STANDARD',    optimizer_inmemory_dml => 'STANDARD',    optimizer_inmemory_ddl => 'STANDARD',    optimizer_inmemory_query_rewrite => 'STANDARD',    optimizer_inmemory_feedback => 'STANDARD',    optimizer_inmemory_statistics => 'STANDARD',    optimizer_inmemory_histograms => 'STANDARD',    optimizer_inmemory_cost => 'STANDARD',    optimizer_inmemory_time => 'STANDARD',    optimizer_inmemory_cardinality => 'STANDARD',    optimizer_inmemory_selectivity => 'STANDARD',    optimizer_inmemory_group_by => 'STANDARD',    optimizer_inmemory_windowing => 'STANDARD',    optimizer_inmemory_aggregation => 'STANDARD',    optimizer_inmemory_pivot => 'STANDARD',    optimizer_inmemory_analytics => 'STANDARD',    optimizer_inmemory_cube => 'STANDARD',    optimizer_inmemory_rollup => 'STANDARD',    optimizer_inmemory_pdb => 'STANDARD',    optimizer_inmemory_dml => 'STANDARD',    optimizer_inmemory_ddl => 'STANDARD',    optimizer_inmemory_query_rewrite => 'STANDARD',    optimizer_inmemory_feedback => 'STANDARD',    optimizer_inmemory_statistics => 'STANDARD',    optimizer_inmemory_histograms => 'STANDARD',    optimizer_inmemory_cost => 'STANDARD',    optimizer_inmemory_time => 'STANDARD',    optimizer_inmemory_cardinality => 'STANDARD',    optimizer_inmemory_selectivity => 'STANDARD',    optimizer_inmemory_group_by => 'STANDARD',    optimizer_inmemory_windowing => 'STANDARD',    optimizer_inmemory_aggregation => 'STANDARD',    optimizer_inmemory_pivot => 'STANDARD',    optimizer_inmemory_analytics => 'STANDARD',    optimizer_inmemory_cube => 'STANDARD',    optimizer_inmemory_rollup => 'STANDARD',    optimizer_inmemory_pdb => 'STANDARD',    optimizer_inmemory_dml => 'STANDARD',    optimizer_inmemory_ddl => 'STANDARD',    optimizer_inmemory_query_rewrite => 'STANDARD',    optimizer_inmemory_feedback => 'STANDARD',    optimizer_inmemory_statistics => 'STANDARD',    optimizer_inmemory_histograms => 'STANDARD',    optimizer_inmemory_cost => 'STANDARD',    optimizer_inmemory_time => 'STANDARD',    optimizer_inmemory_cardinality => 'STANDARD',    optimizer_inmemory_selectivity => 'STANDARD',    optimizer_inmemory_group_by => 'STANDARD',    optimizer_inmemory_windowing => 'STANDARD',    optimizer_inmemory_aggregation => 'STANDARD',    optimizer_inmemory_pivot => 'STANDARD',    optimizer_inmemory_analytics => 'STANDARD',    optimizer_inmemory_cube => 'STANDARD',    optimizer_inmemory_rollup => 'STANDARD',    optimizer_inmemory_pdb => 'STANDARD',    optimizer_inmemory_dml => 'STANDARD',    optimizer_inmemory_ddl => 'STANDARD',    optimizer_inmemory_query_rewrite => 'STANDARD',    optimizer_inmemory_feedback => 'STANDARD',    optimizer_inmemory_statistics => 'STANDARD',    optimizer_inmemory_histograms => 'STANDARD',    optimizer_inmemory_cost => 'STANDARD',    optimizer_inmemory_time => 'STANDARD',    optimizer_inmemory_cardinality => 'STANDARD',    optimizer_inmemory_selectivity => 'STANDARD',    optimizer_inmemory_group_by => 'STANDARD',    optimizer_inmemory_windowing => 'STANDARD',    optimizer_inmemory_aggregation => 'STANDARD',    optimizer_inmemory_pivot => 'STANDARD',    optimizer_inmemory_analytics => 'STANDARD',    optimizer_inmemory_cube => 'STANDARD',    optimizer_inmemory_rollup => 'STANDARD',    optimizer_inmemory_pdb => 'STANDARD',    optimizer_inmemory_dml => 'STANDARD',    optimizer_inmemory_ddl => 'STANDARD',    optimizer_inmemory_query_rewrite => 'STANDARD',    optimizer_inmemory_feedback => 'STANDARD',    optimizer_inmemory_statistics => 'STANDARD',    optimizer_inmemory_histograms => 'STANDARD',    optimizer_inmemory_cost => 'STANDARD',    optimizer_inmemory_time => 'STANDARD',    optimizer_inmemory_cardinality => 'STANDARD',    optimizer_inmemory_selectivity => 'STANDARD',    optimizer_inmemory_group_by => 'STANDARD',    optimizer_inmemory_windowing => 'STANDARD',    optimizer_inmemory_aggregation => 'STANDARD',    optimizer_inmemory_pivot => 'STANDARD',    optimizer_inmemory_analytics => 'STANDARD',    optimizer_inmemory_cube => 'STANDARD',    optimizer_inmemory_rollup => 'STANDARD',    optimizer_inmemory_pdb => 'STANDARD',    optimizer_inmemory_dml => 'STANDARD',    optimizer_inmemory_ddl => 'STANDARD',    optimizer_inmemory_query_rewrite => 'STANDARD',    optimizer_inmemory_feedback => 'STANDARD',    optimizer_inmemory_statistics => 'STANDARD',    optimizer_inmemory_histograms => 'STANDARD',    optimizer_inmemory_cost => 'STANDARD',    optimizer_inmemory_time => 'STANDARD',    optimizer_inmemory_cardinality => 'STANDARD',    optimizer_inmemory_selectivity => 'STANDARD',    optimizer_inmemory_group_by => 'STANDARD',    optimizer_inmemory_windowing => 'STANDARD',    optimizer_inmemory_aggregation => 'STANDARD',    optimizer_inmemory_pivot => 'STANDARD',    optimizer_inmemory_analytics => 'STANDARD',    optimizer_inmemory_cube => 'STANDARD',    optimizer_inmemory_rollup => 'STANDARD',    optimizer_inmemory_pdb => 'STANDARD',    optimizer_inmemory_dml => 'STANDARD',    optimizer_inmemory_ddl => 'STANDARD',    optimizer_inmemory_query_rewrite => 'STANDARD',    optimizer_inmemory_feedback => 'STANDARD',    optimizer_inmemory_statistics => 'STANDARD',    optimizer_inmemory_histograms => 'STANDARD',    optimizer_inmemory_cost => 'STANDARD',    optimizer_inmemory_time => 'STANDARD',    optimizer_inmemory_cardinality => 'STANDARD',    optimizer_inmemory_selectivity => 'STANDARD',    optimizer_inmemory_group_by => 'STANDARD',    optimizer_inmemory_windowing => 'STANDARD',    optimizer_inmemory_aggregation => 'STANDARD',    optimizer_inmemory_pivot => 'STANDARD',    optimizer_inmemory_analytics => 'STANDARD',    optimizer_inmemory_cube => 'STANDARD',    optimizer_inmemory_rollup => 'STANDARD',    optimizer_inmemory_pdb => 'STANDARD',    optimizer_inmemory_dml => 'STANDARD',    optimizer_inmemory_ddl => 'STANDARD',    optimizer_inmemory_query_rewrite => 'STANDARD',    optimizer_inmemory_feedback => 'STANDARD',    optimizer_inmemory_statistics => 'STANDARD',    optimizer_inmemory_histograms => 'STANDARD',    optimizer_inmemory_cost => 'STANDARD',    optimizer_inmemory_time => 'STANDARD',    optimizer_inmemory_cardinality => 'STANDARD',    optimizer_inmemory_selectivity => 'STANDARD',    optimizer_inmemory_group_by => 'STANDARD',    optimizer_inmemory_windowing => 'STANDARD',    optimizer_inmemory_aggregation => 'STANDARD',    optimizer_inmemory_pivot => 'STANDARD',    optimizer_inmemory_analytics => 'STANDARD',    optimizer_inmemory_cube => 'STANDARD',    optimizer_inmemory_rollup => 'STANDARD',    optimizer_inmemory_pdb => 'STANDARD',    optimizer_inmemory_dml => 'STANDARD',    optimizer_inmemory_ddl => 'STANDARD',    optimizer_inmemory_query_rewrite => 'STANDARD',    optimizer_inmemory_feedback => 'STANDARD',    optimizer_inmemory_statistics => 'STANDARD',    optimizer_inmemory_histograms => 'STANDARD',    optimizer_inmemory_cost => 'STANDARD',    optimizer_inmemory_time => 'STANDARD',    optimizer_inmemory_cardinality => 'STANDARD',    optimizer_inmemory_selectivity => 'STANDARD',    optimizer_inmemory_group_by => 'STANDARD',    optimizer_inmemory_windowing => 'STANDARD',    optimizer_inmemory_aggregation => 'STANDARD',    optimizer_inmemory_pivot => 'STANDARD',    optimizer_inmemory_analytics => 'STANDARD',    optimizer_inmemory_cube => 'STANDARD',    optimizer_inmemory_rollup => 'STANDARD',    optimizer_inmemory_pdb => 'STANDARD',    optimizer_inmemory_dml => 'STANDARD',    optimizer_inmemory_ddl => 'STANDARD',    optimizer_inmemory_query_rewrite => 'STANDARD',    optimizer_inmemory_feedback => 'STANDARD',    optimizer_inmemory_statistics => 'STANDARD',    optimizer_inmemory_histograms => 'STANDARD',    optimizer_inmemory_cost => 'STANDARD',    optimizer_inmemory_time => 'STANDARD',    optimizer_inmemory_cardinality => 'STANDARD',    optimizer_inmemory_selectivity => 'STANDARD',    optimizer_inmemory_group_by => 'STANDARD',    optimizer_inmemory_windowing => 'STANDARD',    optimizer_inmemory_aggregation => 'STANDARD',    optimizer_inmemory_pivot => 'STANDARD',    optimizer_inmemory_analytics => 'STANDARD',    optimizer_inmemory_cube => 'STANDARD',    optimizer_inmemory_rollup => 'STANDARD',    optimizer_inmemory_pdb => 'STANDARD',    optimizer_inmemory_dml => 'STANDARD',    optimizer_inmemory_ddl => 'STANDARD',    optimizer_inmemory_query_rewrite => 'STANDARD',    optimizer_inmemory_feedback => 'STANDARD',    optimizer_inmemory_statistics => 'STANDARD',    optimizer_inmemory_histograms => 'STANDARD',    optimizer_inmemory_cost => 'STANDARD',    optimizer_inmemory_time => 'STANDARD',    optimizer_inmemory_cardinality => 'STANDARD',    optimizer_inmemory_selectivity => 'STANDARD',    optimizer_inmemory_group_by => 'STANDARD',    optimizer_inmemory_windowing => 'STANDARD',    optimizer_inmemory_aggregation => 'STANDARD',    optimizer_inmemory_pivot => 'STANDARD',    optimizer_inmemory_analytics => 'STANDARD',    optimizer_inmemory_cube => 'STANDARD',    optimizer_inmemory_rollup => 'STANDARD',    optimizer_inmemory_pdb => 'STANDARD',    optimizer_inmemory_dml => 'STANDARD',    optimizer_inmemory_ddl => 'STANDARD',    optimizer_inmemory_query_rewrite => 'STANDARD',    optimizer_inmemory_feedback => 'STANDARD',    optimizer_inmemory_statistics => 'STANDARD',    optimizer_inmemory_histograms => 'STANDARD',    optimizer_inmemory_cost => 'STANDARD',    optimizer_inmemory_time => 'STANDARD',    optimizer_inmemory_cardinality => 'STANDARD',    optimizer_inmemory_selectivity => 'STANDARD',    optimizer_inmemory_group_by => 'STANDARD',    optimizer_inmemory_windowing => 'STANDARD',    optimizer_inmemory_aggregation => 'STANDARD',    optimizer_inmemory_pivot => 'STANDARD',    optimizer_inmemory_analytics => 'STANDARD',    optimizer_inmemory_cube => 'STANDARD',    optimizer_inmemory_rollup => 'STANDARD',    optimizer_inmemory_pdb => 'STANDARD',    optimizer_inmemory_dml => 'STANDARD',    optimizer_inmemory_ddl => 'STANDARD',    optimizer_inmemory_query_rewrite => 'STANDARD',    optimizer_inmemory_feedback => 'STANDARD',    optimizer_inmemory_statistics => 'STANDARD',    optimizer_inmemory_histograms => 'STANDARD',    optimizer_inmemory_cost => 'STANDARD',    optimizer_inmemory_time => 'STANDARD',    optimizer_inmemory_cardinality => 'STANDARD',    optimizer_inmemory_selectivity => 'STANDARD',    optimizer_inmemory_group_by => 'STANDARD',    optimizer_inmemory_windowing => 'STANDARD',    optimizer_inmemory_aggregation => 'STANDARD',    optimizer_inmemory_pivot => 'STANDARD',    optimizer_inmemory_analytics => 'STANDARD',    optimizer_inmemory_cube => 'STANDARD',    optimizer_inmemory_rollup => 'STANDARD',    optimizer_inmemory_pdb => 'STANDARD',    optimizer_inmemory_dml => 'STANDARD',    optimizer_inmemory_ddl => 'STANDARD',    optimizer_inmemory_query_rewrite => 'STANDARD',    optimizer_inmemory_feedback => 'STANDARD',    optimizer_inmemory_statistics => 'STANDARD',    optimizer_inmemory_histograms => 'STANDARD',    optimizer_inmemory_cost => 'STANDARD',    optimizer_inmemory_time => 'STANDARD',    optimizer_inmemory_cardinality => 'STANDARD',    optimizer_inmemory_selectivity => 'STANDARD',    optimizer_inmemory_group_by => 'STANDARD',    optimizer_inmemory_windowing => 'STANDARD',    optimizer_inmemory_aggregation => 'STANDARD',    optimizer_inmemory_pivot => 'STANDARD',    optimizer_inmemory_analytics => 'STANDARD',    optimizer_inmemory_cube => 'STANDARD',    optimizer_inmemory_rollup => 'STANDARD',    optimizer_inmemory_pdb => 'STANDARD',    optimizer_inmemory_dml => 'STANDARD',    optimizer_inmemory_ddl => 'STANDARD',    optimizer_inmemory_query_rewrite => 'STANDARD',    optimizer_inmemory_feedback => 'STANDARD',    optimizer_inmemory_statistics => 'STANDARD',    optimizer_inmemory_histograms => 'STANDARD',    optimizer_inmemory_cost => 'STANDARD',    optimizer_inmemory_time => 'STANDARD',    optimizer_inmemory_cardinality => 'STANDARD',    optimizer_inmemory_selectivity => 'STANDARD',    optimizer_inmemory_group_by => 'STANDARD',    optimizer_inmemory_windowing => 'STANDARD',    optimizer_inmemory_aggregation => 'STANDARD',    optimizer_inmemory_pivot => 'STANDARD',    optimizer_inmemory_analytics => 'STANDARD',    optimizer_inmemory_cube => 'STANDARD',    optimizer_inmemory_rollup => 'STANDARD',    optimizer_inmemory_pdb => 'STANDARD',    optimizer_inmemory_dml => 'STANDARD',    optimizer_inmemory_ddl => 'STANDARD',    optimizer_inmemory_query_rewrite => 'STANDARD',    optimizer_inmemory_feedback => 'STANDARD',    optimizer_inmemory_statistics => 'STANDARD',    optimizer_inmemory_histograms => 'STANDARD',    optimizer_inmemory_cost => 'STANDARD',    optimizer_inmemory_time => 'STANDARD',    optimizer_inmemory_cardinality => 'STANDARD',    optimizer_inmemory_selectivity => 'STANDARD',    optimizer_inmemory_group_by => 'STANDARD',    optimizer_inmemory_windowing => 'STANDARD',    optimizer_inmemory_aggregation => 'STANDARD',    optimizer_inmemory_pivot => 'STANDARD',    optimizer_inmemory_analytics => 'STANDARD',    optimizer_inmemory_cube => 'STANDARD',    optimizer_inmemory_rollup => 'STANDARD',    optimizer_inmemory_pdb => 'STANDARD',    optimizer_inmemory_dml => 'STANDARD',    optimizer_inmemory_ddl => 'STANDARD',    optimizer_inmemory_query_rewrite => 'STANDARD',    optimizer_inmemory_feedback => 'STANDARD',    optimizer_inmemory_statistics => 'STANDARD',    optimizer_inmemory_histograms => 'STANDARD',    optimizer_inmemory_cost => 'STANDARD',    optimizer_inmemory_time => 'STANDARD',    optimizer_inmemory_cardinality => 'STANDARD',    optimizer_inmemory_selectivity => 'STANDARD',    optimizer_inmemory_group_by => 'STANDARD',    optimizer_inmemory_windowing => 'STANDARD',    optimizer_inmemory_aggregation => 'STANDARD',    optimizer_inmemory_pivot => 'STANDARD',    optimizer_inmemory_analytics => 'STANDARD',    optimizer_inmemory_cube => 'STANDARD',    optimizer_inmemory_rollup => 'STANDARD',    optimizer_inmemory_pdb => 'STANDARD',    optimizer_inmemory_dml => 'STANDARD',    optimizer_inmemory_ddl => 'STANDARD',    optimizer_inmemory_query_rewrite => 'STANDARD',    optimizer_inmemory_feedback => 'STANDARD',    optimizer_inmemory_statistics => 'STANDARD',    optimizer_inmemory_histograms => 'STANDARD',    optimizer_inmemory_cost => 'STANDARD',    optimizer_inmemory_time => 'STANDARD',    optimizer_inmemory_cardinality => 'STANDARD',    optimizer_inmemory_selectivity => 'STANDARD',    optimizer_inmemory_group_by => 'STANDARD',    optimizer_inmemory_windowing => 'STANDARD',    optimizer_inmemory_aggregation => 'STANDARD',    optimizer_inmemory_pivot => 'STANDARD',    optimizer_inmemory_analytics => 'STANDARD',    optimizer_inmemory_cube => 'STANDARD',    optimizer_inmemory_rollup => 'STANDARD',    optimizer_inmemory_pdb => 'STANDARD',    optimizer_inmemory_dml => 'STANDARD',    optimizer_inmemory_ddl => 'STANDARD',    optimizer_inmemory_query_rewrite => 'STANDARD',    optimizer_inmemory_feedback => 'STANDARD',    optimizer_inmemory_statistics => 'STANDARD',    optimizer_inmemory_histograms => 'STANDARD',    optimizer_inmemory_cost => 'STANDARD',    optimizer_inmemory_time => 'STANDARD',    optimizer_inmemory_cardinality => 'STANDARD',    optimizer_inmemory_selectivity => 'STANDARD',    optimizer_inmemory_group_by => 'STANDARD',    optimizer_inmemory_windowing => 'STANDARD',    optimizer_inmemory_aggregation => 'STANDARD',    optimizer_inmemory_pivot => 'STANDARD',    optimizer_inmemory_analytics => 'STANDARD',    optimizer_inmemory_cube => 'STANDARD',    optimizer_inmemory_rollup => 'STANDARD',    optimizer_inmemory_pdb => 'STANDARD',    optimizer_inmemory_dml => 'STANDARD',    optimizer_inmemory_ddl => 'STANDARD',    optimizer_inmemory_query_rewrite => 'STANDARD',    optimizer_inmemory_feedback => 'STANDARD',    optimizer_inmemory_statistics => 'STANDARD',    optimizer_inmemory_histograms => 'STANDARD',    optimizer_inmemory_cost => 'STANDARD',    optimizer_inmemory_time => 'STANDARD',    optimizer_inmemory_cardinality => 'STANDARD',    optimizer_inmemory_selectivity => 'STANDARD',    optimizer_inmemory_group_by => 'STANDARD',    optimizer_inmemory_windowing => 'STANDARD',    optimizer_inmemory_aggregation => 'STANDARD',    optimizer_inmemory_pivot => 'STANDARD',    optimizer_inmemory_analytics => 'STANDARD',    optimizer_inmemory_cube => 'STANDARD',    optimizer_inmemory_rollup => 'STANDARD',    optimizer_inmemory_pdb => 'STANDARD',    optimizer_inmemory_dml => 'STANDARD',    optimizer_inmemory_ddl => 'STANDARD',    optimizer_inmemory_query_rewrite => 'STANDARD',    optimizer_inmemory_feedback => 'STANDARD',    optimizer_inmemory_statistics => 'STANDARD',    optimizer_inmemory_histograms => 'STANDARD',    optimizer_inmemory_cost => 'STANDARD',    optimizer_inmemory_time => 'STANDARD',    optimizer_inmemory_cardinality => 'STANDARD',