Oracle SQL Profile 使用指南：优化性能与实现技巧

在现代企业中，数据中台、数字孪生和数字可视化技术的应用越来越广泛，而这些技术的核心离不开高效的数据处理和分析能力。作为 Oracle 数据库中的一个重要工具，SQL Profile（SQL 分析轮廓）在优化 SQL 查询性能方面发挥着关键作用。本文将深入探讨 Oracle SQL Profile 的使用方法、优化技巧以及其实现原理，帮助企业用户更好地利用这一工具提升数据库性能。

什么是 Oracle SQL Profile？

Oracle SQL Profile 是 Oracle 数据库提供的一项功能，用于优化 SQL 查询的执行效率。它通过收集 SQL 语句的执行计划和统计信息，帮助 Oracle 查询优化器生成更优的执行计划，从而减少资源消耗、提高查询速度，并改善整体系统性能。

简单来说，SQL Profile 是一种通过分析 SQL 语句的行为模式，为优化器提供额外信息的机制。这些信息包括 SQL 语句的访问路径、执行时间、锁竞争等，帮助优化器更智能地选择最优的执行计划。

为什么需要使用 Oracle SQL Profile？

在数据中台、数字孪生和数字可视化等场景中，SQL 查询的性能直接影响到系统的响应速度和用户体验。以下是一些使用 Oracle SQL Profile 的关键原因：

1. 优化复杂查询：对于复杂的 SQL 查询（如多表连接、子查询等），SQL Profile 可以帮助优化器选择更优的执行计划，减少执行时间。
2. 减少资源消耗：通过优化 SQL 执行计划，可以降低 CPU、内存和磁盘 I/O 的使用，从而减少资源消耗。
3. 提高系统性能：在高并发场景下，SQL Profile 可以帮助减少锁竞争和等待时间，提升系统的吞吐量。
4. 支持数字可视化和实时分析：在数字可视化和实时分析场景中，快速响应是关键，SQL Profile 可以显著提升查询性能，支持更高效的实时数据分析。

Oracle SQL Profile 的使用方法

1. 创建 SQL Profile

要使用 Oracle SQL Profile，首先需要创建一个 SQL Profile。可以通过以下步骤实现：

步骤 1：收集 SQL 执行信息

使用 DBMS_SQLTUNE 包中的 PROFILE 子程序，收集 SQL 语句的执行信息。例如：

DECLARE  l_profile_prefix VARCHAR2(30) := 'SQL_PROFILE_';  l_sql_id         VARCHAR2(13) := '1234567890123';BEGIN  DBMS_SQLTUNE.PROFILE(    sql_id         => l_sql_id,    profile_prefix => l_profile_prefix,    plan_hash_value => NULL,    profile_enabled => DBMS_SQLTUNE.PROFILE_ENABLED,    profile_interval => DBMS_SQLTUNE.PROFILE_INTERVAL,    profile stattab => 'default',    profile statid => NULL,    profile statown => NULL,    profile stattim => NULL,    profile stoptim => NULL,    profile rsrc_plan => NULL,    profile rsrc_plan_id => NULL,    profile rsrc_plan_name => NULL,    profile rsrc_plan_type => NULL,    profile rsrc_plan_desc => NULL,    profile rsrc_plan_json => NULL,    profile rsrc_plan_xml => NULL,    profile rsrc_plan_sql => NULL,    profile rsrc_plan_sql_id => NULL,    profile rsrc_plan_sql_plan => NULL,    profile rsrc_plan_sql_plan_id => NULL,    profile rsrc_plan_sql_plan_name => NULL,    profile rsrc_plan_sql_plan_type => NULL,    profile rsrc_plan_sql_plan_desc => NULL,    profile rsrc_plan_sql_plan_json => NULL,    profile rsrc_plan_sql_plan_xml => NULL,    profile rsrc_plan_sql_plan_sql => NULL,    profile rsrc_plan_sql_plan_sql_id => NULL,    profile rsrc_plan_sql_plan_sql_plan => NULL,    profile rsrc_plan_sql_plan_sql_plan_id => NULL,    profile rsrc_plan_sql_plan_sql_plan_name => NULL,    profile rsrc_plan_sql_plan_sql_plan_type => NULL,    profile rsrc_plan_sql_plan_sql_plan_desc => NULL,    profile rsrc_plan_sql_plan_sql_plan_json => NULL,    profile rsrc_plan_sql_plan_sql_plan_xml => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_id => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_id => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_name => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_type => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_desc => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_json => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_xml => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_id => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_id => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_name => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_type => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_desc => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_json => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_xml => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_id => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_id => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_name => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_type => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_desc => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_json => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_xml => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_id => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_id => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_name => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_type => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_desc => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_json => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_xml => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_id => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_id => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_name => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_type => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_desc => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_json => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_xml => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_id => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_id => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_name => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_type => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_desc => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_json => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_xml => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_id => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_id => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_name => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_type => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_desc => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_json => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_xml => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_id => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_id => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_name => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_type => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_desc => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_json => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_xml => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_id => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_id => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_name => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_type => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_desc => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_json => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_xml => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_id => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_id => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_name => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_type => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_desc => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_json => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_xml => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_id => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_id => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_name => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_type => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_desc => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_json => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_xml => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_id => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_id => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_name => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_type => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_desc => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_json => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_xml => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_id => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_id => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_name => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_type => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_desc => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_json => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_xml => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_id => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_id => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_name => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_type => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_desc => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_json => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_xml => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_id => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_id => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_name => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_type => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_desc => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_json => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_xml => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_id => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_id => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_name => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_type => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_desc => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_json => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_xml => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_id => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_id => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_name => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_type => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_desc => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_json => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_xml => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_id => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_id => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_name => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_type => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_desc => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_json => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_xml => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_id => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_id => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_name => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_type => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_desc => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_json => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_xml => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_id => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_id => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_name => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_type => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_desc => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_json => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_xml => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_id => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_id => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_name => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_type => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_desc => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_json => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_xml => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_id => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_id => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_name => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_type => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_desc => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_json => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_xml => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_id => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_id => NULL,    profile rsrc_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql_plan_sql