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

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

什么是 Oracle SQL Profile？

Oracle SQL Profile 是一种用于优化 SQL 查询性能的工具，它通过分析和评估 SQL 语句的执行计划，提供改进建议，从而帮助数据库管理员（DBA）和开发人员优化 SQL 查询的执行效率。SQL Profile 可以通过以下两种方式生成：

1. 自动 SQL Tuning Advisor：Oracle 数据库自带的自动优化工具，会自动分析 SQL 查询的执行计划，并生成 SQL Profile。
2. 手动创建：DBA 或开发人员可以根据需要手动创建 SQL Profile。

SQL Profile 包含以下关键信息：

• 执行计划：SQL 语句的详细执行步骤。
• 优化建议：针对 SQL 语句的改进建议，例如索引调整、查询重写等。
• 性能指标：SQL 语句的执行时间、资源消耗等性能数据。

SQL Profile 的作用

1. 优化查询性能：通过分析 SQL 语句的执行计划，SQL Profile 可以识别性能瓶颈，并提供优化建议。
2. 提高用户体验：优化后的 SQL 查询可以显著减少响应时间，提升用户满意度。
3. 降低资源消耗：通过减少不必要的资源消耗，SQL Profile 可以帮助企业在有限的硬件资源下实现更高的性能。
4. 支持数据中台：在数据中台场景中，SQL Profile 可以帮助优化复杂的查询，提升数据处理效率，支持实时数据分析需求。

SQL Profile 的使用技巧

1. 如何创建 SQL Profile？

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

1. 使用 SQL Tuning Advisor：

   DECLARE  l_sql_tuning_task_id NUMBER;BEGIN  DBMS_SQLTUNE.CREATE_TUNING_TASK(    sql_id => 'SQL_ID',    task_name => 'Tuning Task Name',    description => 'Tuning Task Description',    tuning_mode => DBMS_SQLTUNE.TUNING_MODE_AUTO,    user_name => NULL,    credential => NULL,    credential_password => NULL,    credential_type => NULL,    credential_scope => NULL,    credential_reuse => NULL,    credential_purge => NULL,    credential_purge_time => NULL,    credential_purge_interval => NULL,    credential_purge_count => NULL,    credential_purge_policy => NULL,    credential_purge_threshold => NULL,    credential_purge_condition => NULL,    credential_purge_action => NULL,    credential_purge_result => NULL,    credential_purge_result_type => NULL,    credential_purge_result_format => NULL,    credential_purge_result_display => NULL,    credential_purge_result_threshold => NULL,    credential_purge_result_policy => NULL,    credential_purge_result_action => NULL,    credential_purge_result_count => NULL,    credential_purge_result_interval => NULL,    credential_purge_result_time => NULL,    credential_purge_result_scope => NULL,    credential_purge_result_type => NULL,    credential_purge_result_format => NULL,    credential_purge_result_display => NULL,    credential_purge_result_threshold => NULL,    credential_purge_result_policy => NULL,    credential_purge_result_action => NULL,    credential_purge_result_count => NULL,    credential_purge_result_interval => NULL,    credential_purge_result_time => NULL,    credential_purge_result_scope => NULL,    credential_purge_result_type => NULL,    credential_purge_result_format => NULL,    credential_purge_result_display => NULL,    credential_purge_result_threshold => NULL,    credential_purge_result_policy => NULL,    credential_purge_result_action => NULL,    credential_purge_result_count => NULL,    credential_purge_result_interval => NULL,    credential_purge_result_time => NULL,    credential_purge_result_scope => NULL,    credential_purge_result_type => NULL,    credential_purge_result_format => NULL,    credential_purge_result_display => NULL,    credential_purge_result_threshold => NULL,    credential_purge_result_policy => NULL,    credential_purge_result_action => NULL,    credential_purge_result_count => NULL,    credential_purge_result_interval => NULL,    credential_purge_result_time => NULL,    credential_purge_result_scope => NULL,    credential_purge_result_type => NULL,    credential_purge_result_format => NULL,    credential_purge_result_display => NULL,    credential_purge_result_threshold => NULL,    credential_purge_result_policy => NULL,    credential_purge_result_action => NULL,    credential_purge_result_count => NULL,    credential_purge_result_interval => NULL,    credential_purge_result_time => NULL,    credential_purge_result_scope => NULL,    credential_purge_result_type => NULL,    credential_purge_result_format => NULL,    credential_purge_result_display => NULL,    credential_purge_result_threshold => NULL,    credential_purge_result_policy => NULL,    credential_purge_result_action => NULL,    credential_purge_result_count => NULL,    credential_purge_result_interval => NULL,    credential_purge_result_time => NULL,    credential_purge_result_scope => NULL,    credential_purge_result_type => NULL,    credential_purge_result_format => NULL,    credential_purge_result_display => NULL,    credential_purge_result_threshold => NULL,    credential_purge_result_policy => NULL,    credential_purge_result_action => NULL,    credential_purge_result_count => NULL,    credential_purge_result_interval => NULL,    credential_purge_result_time => NULL,    credential_purge_result_scope => NULL,    credential_purge_result_type => NULL,    credential_purge_result_format => NULL,    credential_purge_result_display => NULL,    credential_purge_result_threshold => NULL,    credential_purge_result_policy => NULL,    credential_purge_result_action => NULL,    credential_purge_result_count => NULL,    credential_purge_result_interval => NULL,    credential_purge_result_time => NULL,    credential_purge_result_scope => NULL,    credential_purge_result_type => NULL,    credential_purge_result_format => NULL,    credential_purge_result_display => NULL,    credential_purge_result_threshold => NULL,    credential_purge_result_policy => NULL,    credential_purge_result_action => NULL,    credential_purge_result_count => NULL,    credential_purge_result_interval => NULL,    credential_purge_result_time => NULL,    credential_purge_result_scope => NULL,    credential_purge_result_type => NULL,    credential_purge_result_format => NULL,    credential_purge_result_display => NULL,    credential_purge_result_threshold => NULL,    credential_purge_result_policy => NULL,    credential_purge_result_action => NULL,    credential_purge_result_count => NULL,    credential_purge_result_interval => NULL,    credential_purge_result_time => NULL,    credential_purge_result_scope => NULL,    credential_purge_result_type => NULL,    credential_purge_result_format => NULL,    credential_purge_result_display => NULL,    credential_purge_result_threshold => NULL,    credential_purge_result_policy => NULL,    credential_purge_result_action => NULL,    credential_purge_result_count => NULL,    credential_purge_result_interval => NULL,    credential_purge_result_time => NULL,    credential_purge_result_scope => NULL,    credential_purge_result_type => NULL,    credential_purge_result_format => NULL,    credential_purge_result_display => NULL,    credential_purge_result_threshold => NULL,    credential_purge_result_policy => NULL,    credential_purge_result_action => NULL,    credential_purge_result_count => NULL,    credential_purge_result_interval => NULL,    credential_purge_result_time => NULL,    credential_purge_result_scope => NULL,    credential_purge_result_type => NULL,    credential_purge_result_format => NULL,    credential_purge_result_display => NULL,    credential_purge_result_threshold => NULL,    credential_purge_result_policy => NULL,    credential_purge_result_action => NULL,    credential_purge_result_count => NULL,    credential_purge_result_interval => NULL,    credential_purge_result_time => NULL,    credential_purge_result_scope => NULL,    credential_purge_result_type => NULL,    credential_purge_result_format => NULL,    credential_purge_result_display => NULL,    credential_purge_result_threshold => NULL,    credential_purge_result_policy => NULL,    credential_purge_result_action => NULL,    credential_purge_result_count => NULL,    credential_purge_result_interval => NULL,    credential_purge_result_time => NULL,    credential_purge_result_scope => NULL,    credential_purge_result_type => NULL,    credential_purge_result_format => NULL,    credential_purge_result_display => NULL,    credential_purge_result_threshold => NULL,    credential_purge_result_policy => NULL,    credential_purge_result_action => NULL,    credential_purge_result_count => NULL,    credential_purge_result_interval => NULL,    credential_purge_result_time => NULL,    credential_purge_result_scope => NULL,    credential_purge_result_type => NULL,    credential_purge_result_format => NULL,    credential_purge_result_display => NULL,    credential_purge_result_threshold => NULL,    credential_purge_result_policy => NULL,    credential_purge_result_action => NULL,    credential_purge_result_count => NULL,    credential_purge_result_interval => NULL,    credential_purge_result_time => NULL,    credential_purge_result_scope => NULL,    credential_purge_result_type => NULL,    credential_purge_result_format => NULL,    credential_purge_result_display => NULL,    credential_purge_result_threshold => NULL,    credential_purge_result_policy => NULL,    credential_purge_result_action => NULL,    credential_purge_result_count => NULL,    credential_purge_result_interval => NULL,    credential_purge_result_time => NULL,    credential_purge_result_scope => NULL,    credential_purge_result_type => NULL,    credential_purge_result_format => NULL,    credential_purge_result_display => NULL,    credential_purge_result_threshold => NULL,    credential_purge_result_policy => NULL,    credential_purge_result_action => NULL,    credential_purge_result_count => NULL,    credential_purge_result_interval => NULL,    credential_purge_result_time => NULL,    credential_purge_result_scope => NULL,    credential_purge_result_type => NULL,    credential_purge_result_format => NULL,    credential_purge_result_display => NULL,    credential_purge_result_threshold => NULL,    credential_purge_result_policy => NULL,    credential_purge_result_action => NULL,    credential_purge_result_count => NULL,    credential_purge_result_interval => NULL,    credential_purge_result_time => NULL,    credential_purge_result_scope => NULL,    credential_purge_result_type => NULL,    credential_purge_result_format => NULL,    credential_purge_result_display => NULL,    credential_purge_result_threshold => NULL,    credential_purge_result_policy => NULL,    credential_purge_result_action => NULL,    credential_purge_result_count => NULL,    credential_purge_result_interval => NULL,    credential_purge_result_time => NULL,    credential_purge_result_scope => NULL,    credential_purge_result_type => NULL,    credential_purge_result_format => NULL,    credential_purge_result_display => NULL,    credential_purge_result_threshold => NULL,    credential_purge_result_policy => NULL,    credential_purge_result_action => NULL,    credential_purge_result_count => NULL,    credential_purge_result_interval => NULL,    credential_purge_result_time => NULL,    credential_purge_result_scope => NULL,    credential_purge_result_type => NULL,    credential_purge_result_format => NULL,    credential_purge_result_display => NULL,    credential_purge_result_threshold => NULL,    credential_purge_result_policy => NULL,    credential_purge_result_action => NULL,    credential_purge_result_count => NULL,    credential_purge_result_interval => NULL,    credential_purge_result_time => NULL,    credential_purge_result_scope => NULL,    credential_purge_result_type => NULL,    credential_purge_result_format => NULL,    credential_purge_result_display => NULL,    credential_purge_result_threshold => NULL,    credential_purge_result_policy => NULL,    credential_purge_result_action => NULL,    credential_purge_result_count => NULL,    credential_purge_result_interval => NULL,    credential_purge_result_time => NULL,    credential_purge_result_scope => NULL,    credential_purge_result_type => NULL,    credential_purge_result_format => NULL,    credential_purge_result_display => NULL,    credential_purge_result_threshold => NULL,    credential_purge_result_policy => NULL,    credential_purge_result_action => NULL,    credential_purge_result_count => NULL,    credential_purge_result_interval => NULL,    credential_purge_result_time => NULL,    credential_purge_result_scope => NULL,    credential_purge_result_type => NULL,    credential_purge_result_format => NULL,    credential_purge_result_display => NULL,    credential_purge_result_threshold => NULL,    credential_purge_result_policy => NULL,    credential_purge_result_action => NULL,    credential_purge_result_count => NULL,    credential_purge_result_interval => NULL,    credential_purge_result_time => NULL,    credential_purge_result_scope => NULL,    credential_purge_result_type => NULL,    credential_purge_result_format => NULL,    credential_purge_result_display => NULL,    credential_purge_result_threshold => NULL,    credential_purge_result_policy => NULL,    credential_purge_result_action => NULL,    credential_purge_result_count => NULL,    credential_purge_result_interval => NULL,    credential_purge_result_time => NULL,    credential_purge_result_scope => NULL,    credential_purge_result_type => NULL,    credential_purge_result_format => NULL,    credential_purge_result_display => NULL,    credential_purge_result_threshold => NULL,    credential_purge_result_policy => NULL,    credential_purge_result_action => NULL,    credential_purge_result_count => NULL,    credential_purge_result_interval => NULL,    credential_purge_result_time => NULL,    credential_purge_result_scope => NULL,    credential_purge_result_type => NULL,    credential_purge_result_format => NULL,    credential_purge_result_display => NULL,    credential_purge_result_threshold => NULL,    credential_purge_result_policy => NULL,    credential_purge_result_action => NULL,    credential_purge_result_count => NULL,    credential_purge_result_interval => NULL,    credential_purge_result_time => NULL,    credential_purge_result_scope => NULL,    credential_purge_result_type => NULL,    credential_purge_result_format => NULL,    credential_purge_result_display => NULL,    credential_purge_result_threshold => NULL,    credential_purge_result_policy => NULL,    credential_purge_result_action => NULL,    credential_purge_result_count => NULL,    credential_purge_result_interval => NULL,    credential_purge_result_time => NULL,    credential_purge_result_scope => NULL,    credential_purge_result_type => NULL,    credential_purge_result_format => NULL,    credential_purge_result_display => NULL,    credential_purge_result_threshold => NULL,    credential_purge_result_policy => NULL,    credential_purge_result_action => NULL,    credential_purge_result_count => NULL,    credential_purge_result_interval => NULL,    credential_purge_result_time => NULL,    credential_purge_result_scope => NULL,    credential_purge_result_type => NULL,    credential_purge_result_format => NULL,    credential_purge_result_display => NULL,    credential_purge_result_threshold => NULL,    credential_purge_result_policy => NULL,    credential_purge_result_action => NULL,    credential_purge_result_count => NULL,    credential_purge_result_interval => NULL,    credential_purge_result_time => NULL,    credential_purge_result_scope => NULL,    credential_purge_result_type => NULL,    credential_purge_result_format => NULL,    credential_purge_result_display => NULL,    credential_purge_result_threshold => NULL,    credential_purge_result_policy => NULL,    credential_purge_result_action => NULL,    credential_purge_result_count => NULL,    credential_purge_result_interval => NULL,    credential_purge_result_time => NULL,    credential_purge_result_scope => NULL,    credential_purge_result_type => NULL,    credential_purge_result_format => NULL,    credential_purge_result_display => NULL,    credential_purge_result_threshold => NULL,    credential_purge_result_policy => NULL,    credential_purge_result_action => NULL,    credential_purge_result_count => NULL,    credential_purge_result_interval => NULL,    credential_purge_result_time => NULL,    credential_purge_result_scope => NULL,    credential_purge_result_type => NULL,    credential_purge_result_format => NULL,    credential_purge_result_display => NULL,    credential_purge_result_threshold => NULL,    credential_purge_result_policy => NULL,    credential_purge_result_action => NULL,    credential_purge_result_count => NULL,    credential_purge_result_interval => NULL,    credential_purge_result_time => NULL,    credential_purge_result_scope => NULL,    credential_purge_result_type => NULL,    credential_purge_result_format => NULL,    credential_purge_result_display => NULL,    credential_purge_result_threshold => NULL,    credential_purge_result_policy => NULL,    credential_purge_result_action => NULL,    credential_purge_result_count => NULL,    credential_purge_result_interval => NULL,    credential_purge_result_time => NULL,    credential_purge_result_scope => NULL,    credential_purge_result_type => NULL,    credential_purge_result_format => NULL,    credential_purge_result_display => NULL,    credential_purge_result_threshold => NULL,    credential_purge_result_policy => NULL,    credential_purge_result_action => NULL,    credential_purge_result_count => NULL,    credential_purge_result_interval => NULL,    credential_purge_result_time => NULL,    credential_purge_result_scope => NULL,    credential_purge_result_type => NULL,    credential_purge_result_format => NULL,    credential_purge_result_display => NULL,    credential_purge_result_threshold => NULL,    credential_purge_result_policy => NULL,    credential_purge_result_action => NULL,    credential_purge_result_count => NULL,    credential_purge_result_interval => NULL,    credential_purge_result_time => NULL,    credential_purge_result_scope => NULL,    credential_purge_result_type => NULL,    credential_purge_result_format => NULL,    credential_purge_result_display => NULL,    credential_purge_result_threshold => NULL,    credential_purge_result_policy => NULL,    credential_purge_result_action => NULL,    credential_purge_result_count => NULL,    credential_purge_result_interval => NULL,    credential_purge_result_time => NULL,    credential_purge_result_scope => NULL,    credential_purge_result_type => NULL,    credential_purge_result_format => NULL,    credential_purge_result_display => NULL,    credential_purge_result_threshold => NULL,    credential_purge_result_policy => NULL,    credential_purge_result_action => NULL,    credential_purge_result_count => NULL,    credential_purge_result_interval => NULL,    credential_purge_result_time => NULL,    credential_purge_result_scope => NULL,    credential_purge_result_type => NULL,    credential_purge_result_format => NULL,    credential_purge_result_display => NULL,    credential_purge_result_threshold => NULL,    credential_purge_result_policy => NULL,    credential_purge_result_action => NULL,    credential_purge_result_count => NULL,    credential_purge_result_interval => NULL,    credential_purge_result_time => NULL,    credential_purge_result_scope => NULL,    credential_purge_result_type => NULL,    credential_purge_result_format => NULL,    credential_purge_result_display => NULL,    credential_purge_result_threshold => NULL,    credential_purge_result_policy => NULL,    credential_purge_result_action => NULL,    credential_purge_result_count => NULL,    credential_purge_result_interval => NULL,    credential_purge_result_time => NULL,    credential_purge_result_scope => NULL,    credential_purge_result_type => NULL,    credential_purge_result_format => NULL,    credential_purge_result_display => NULL,    credential_purge_result_threshold => NULL,    credential_purge_result_policy => NULL,    credential_purge_result_action => NULL,    credential_purge_result_count => NULL,    credential_purge_result_interval => NULL,    credential_purge_result_time => NULL,    credential_purge_result_scope => NULL,    credential_purge_result_type => NULL,    credential_purge_result_format => NULL,    credential_purge_result_display => NULL,    credential_purge_result_threshold => NULL,    credential_purge_result_policy => NULL,    credential_purge_result_action => NULL,    credential_purge_result_count => NULL,    credential_purge_result_interval => NULL,    credential_purge_result_time => NULL,    credential_purge_result_scope => NULL,    credential_purge_result_type => NULL,    credential_purge_result_format => NULL,    credential_purge_result_display => NULL,    credential_purge_result_threshold => NULL,    credential_purge_result_policy => NULL,    credential_purge_result_action => NULL,    credential_purge_result_count => NULL,    credential_purge_result_interval => NULL,    credential_purge_result_time => NULL,    credential_purge_result_scope => NULL,    credential_purge_result_type => NULL,    credential_purge_result_format => NULL,    credential_purge_result_display => NULL,    credential_purge_result_threshold => NULL,    credential_purge_result_policy => NULL,    credential_purge_result_action => NULL,    credential_purge_result_count => NULL,    credential_purge_result_interval => NULL,    credential_purge_result_time => NULL,    credential_purge_result_scope => NULL,    credential_purge_result_type => NULL,    credential_purge_result_format => NULL,    credential_purge_result_display => NULL,    credential_purge_result_threshold => NULL,    credential_purge_result_policy => NULL,    credential_purge_result_action => NULL,    credential_purge_result_count => NULL,    credential_purge_result_interval => NULL,    credential_purge_result_time => NULL,    credential_purge_result_scope => NULL,    credential_purge_result_type => NULL,    credential_purge_result_format => NULL,    credential_purge_result_display => NULL,    credential_purge_result_threshold => NULL,    credential_purge_result_policy => NULL,    credential_purge_result_action => NULL,    credential_purge_result_count => NULL,    credential_purge_result_interval => NULL,    credential_purge_result_time => NULL,    credential_purge_result_scope => NULL,    credential_purge_result_type => NULL,    credential_purge_result_format => NULL,    credential_purge_result_display => NULL,    credential_purge_result_threshold => NULL,    credential_purge_result_policy => NULL,    credential_purge_result_action => NULL,    credential_purge_result_count => NULL,    credential_purge_result_interval => NULL,    credential_purge_result_time => NULL,    credential_purge_result_scope => NULL,    credential_purge_result_type => NULL,    credential_purge_result_format => NULL,    credential_purge_result_display => NULL,    credential_purge_result_threshold => NULL,    credential_purge_result_policy => NULL,    credential_purge_result_action => NULL,    credential_purge_result_count => NULL,    credential_purge_result_interval => NULL,    credential_purge_result_time => NULL,    credential_purge_result_scope => NULL,    credential_purge_result_type => NULL,    credential_purge_result_format => NULL,    credential_purge_result_display => NULL,    credential_purge_result_threshold => NULL,    credential_purge_result_policy => NULL,    credential_purge_result_action => NULL,    credential_purge_result_count => NULL,    credential_purge_result_interval => NULL,    credential_purge_result_time => NULL,    credential_purge_result_scope => NULL,    credential_purge_result_type => NULL,    credential_purge_result_format => NULL,    credential_purge_result_display => NULL,    credential_purge_result_threshold => NULL,    credential_purge_result_policy => NULL,    credential_purge_result_action => NULL,    credential_purge_result_count => NULL,    credential_purge_result_interval => NULL,    credential_purge_result_time => NULL,    credential_purge_result_scope => NULL,    credential_purge_result_type => NULL,    credential_purge_result_format => NULL,    credential_purge_result_display => NULL,    credential_purge_result_threshold => NULL,    credential_purge_result_policy => NULL,    credential_purge_result_action => NULL,    credential_purge_result_count => NULL,    credential_purge_result_interval => NULL,    credential_purge_result_time => NULL,    credential_purge_result_scope => NULL,    credential_purge_result_type => NULL,    credential_purge_result_format => NULL,    credential_purge_result_display => NULL,    credential_purge_result_threshold => NULL,    credential_purge_result_policy => NULL,    credential_purge_result_action => NULL,    credential_purge_result_count => NULL,    credential_purge_result_interval => NULL,    credential_purge_result_time => NULL,    credential_purge_result_scope => NULL,    credential_purge_result_type => NULL,    credential_purge_result_format => NULL,    credential_purge_result_display => NULL,    credential_purge_result_threshold => NULL,    credential_purge_result_policy => NULL,    credential_purge_result_action => NULL,    credential_purge_result_count => NULL,    credential_purge_result_interval => NULL,    credential_purge_result_time => NULL,    credential_purge_result_scope => NULL,    credential_purge_result_type => NULL,    credential_purge_result_format => NULL,    credential_purge_result_display => NULL,    credential_purge_result_threshold => NULL,    credential_purge_result_policy => NULL,    credential_purge_result_action => NULL,    credential_purge_result_count => NULL,    credential_purge_result_interval => NULL,    credential_purge_result_time => NULL,    credential_purge_result_scope => NULL,    credential_purge_result_type => NULL,    credential_purge_result_format => NULL,    credential_purge_result_display => NULL,    credential_purge_result_threshold => NULL,    credential_purge_result_policy => NULL,    credential_purge_result_action => NULL,    credential_purge_result_count => NULL,    credential_purge_result_interval => NULL,    credential_purge_result_time => NULL,    credential_purge_result_scope => NULL,    credential_purge_result_type => NULL,    credential_purge_result_format => NULL,    credential_purge_result_display => NULL,    credential_purge_result_threshold => NULL,    credential_purge_result_policy => NULL,    credential_purge_result_action => NULL,    credential_purge_result_count => NULL,    credential_purge_result_interval => NULL,    credential_purge_result_time => NULL,    credential_purge_result_scope => NULL,    credential_purge_result_type => NULL,    credential_purge_result_format => NULL,    credential_purge_result_display => NULL,    credential_purge_result_threshold => NULL,    credential_purge_result_policy => NULL,    credential_purge_result_action => NULL,    credential_purge_result_count => NULL,    credential_purge_result_interval => NULL,    credential_purge_result_time => NULL,    credential_purge_result_scope => NULL,    credential_purge_result_type => NULL,    credential_purge_result_format => NULL,    credential_purge_result_display => NULL,    credential_purge_result_threshold => NULL,    credential_purge_result_policy => NULL,    credential_purge_result_action => NULL,    credential_purge_result_count => NULL,    credential_purge_result_interval => NULL,    credential_purge_result_time => NULL,    credential_purge_result_scope => NULL,    credential_purge_result_type => NULL,    credential_purge_result_format => NULL,    credential_purge_result_display => NULL,    credential_purge_result_threshold => NULL,    credential_purge_result_policy => NULL,    credential_purge_result_action => NULL,    credential_purge_result_count => NULL,    credential_purge_result_interval => NULL,    credential_purge_result_time => NULL,    credential_purge_result_scope => NULL,    credential_purge_result_type => NULL,    credential_purge_result_format => NULL,    credential_purge_result_display => NULL,    credential_purge_result_threshold => NULL,    credential_purge_result_policy => NULL,    credential_purge_result_action => NULL,    credential_purge_result_count => NULL,    credential_purge_result_interval => NULL,    credential_purge_result_time => NULL,    credential_purge_result_scope => NULL,    credential_purge_result_type => NULL,    credential_purge_result_format => NULL,    credential_purge_result_display => NULL,    credential_purge_result_threshold => NULL,    credential_purge_result_policy => NULL,    credential_purge_result_action => NULL,    credential_purge_result_count => NULL,    credential_purge_result_interval => NULL,    credential_purge_result_time => NULL,    credential_purge_result_scope => NULL,    credential_purge_result_type => NULL,    credential_purge_result_format => NULL,    credential_purge_result_display => NULL,    credential_purge_result_threshold => NULL,    credential_purge_result_policy => NULL,    credential_purge_result_action => NULL,    credential_purge_result_count => NULL,    credential_purge_result_interval => NULL,    credential_purge_result_time => NULL,    credential_purge_result_scope => NULL,    credential_purge_result_type => NULL,    credential_purge_result_format => NULL,    credential_purge_result_display => NULL,    credential_purge_result_threshold => NULL,    credential_purge_result_policy => NULL,    credential_purge_result_action => NULL,    credential_purge_result_count => NULL,    credential_purge_result_interval => NULL,    credential_purge_result_time => NULL,    credential_purge_result_scope => NULL,    credential_purge_result_type => NULL,    credential_purge_result_format => NULL,    credential_purge_result_display => NULL,    credential_purge_result_threshold => NULL,    credential_purge_result_policy => NULL,    credential_purge_result_action => NULL,    credential_purge_result_count => NULL,    credential_purge_result_interval => NULL,    credential_purge_result_time => NULL,    credential_purge_result_scope => NULL,    credential_purge_result_type => NULL,    credential_purge_result_format => NULL,    credential_purge_result_display => NULL,    credential_purge_result_threshold => NULL,    credential_purge_result_policy => NULL,    credential_purge_result_action => NULL,    credential_purge_result_count => NULL,    credential_purge_result_interval => NULL,    credential_purge_result_time => NULL,    credential_purge_result_scope => NULL,    credential_purge_result_type => NULL,    credential_purge_result_format => NULL,    credential_purge_result_display => NULL,    credential_purge_result_threshold => NULL,    credential_purge_result_policy => NULL,    credential_purge_result_action => NULL,    credential_purge_result_count => NULL,    credential_purge_result_interval => NULL,    credential_purge_result_time => NULL,    credential_purge_result_scope => NULL,    credential_purge_result_type => NULL,    credential_purge_result_format => NULL,    credential_purge_result_display => NULL,    credential_purge_result_threshold => NULL,    credential_purge_result_policy => NULL,    credential_purge_result_action => NULL,    credential_purge_result_count => NULL,    credential_purge_result_interval => NULL,    credential_purge_result_time => NULL,    credential_purge_result_scope => NULL,    credential_purge_result_type => NULL,    credential_purge_result_format => NULL,    credential_purge_result_display => NULL,    credential_purge_result_threshold => NULL,    credential_purge_result_policy => NULL,    credential_purge_result_action => NULL,    credential_purge_result_count => NULL,    credential_purge_result_interval => NULL,    credential_purge_result_time => NULL,    credential_purge_result_scope => NULL,    credential_purge_result_type => NULL,    credential_purge_result_format => NULL,    credential_purge_result_display => NULL,    credential_purge_result_threshold => NULL,    credential_purge_result_policy => NULL,    credential_purge_result_action => NULL,    credential_purge_result_count => NULL,    credential_purge_result_interval => NULL,    credential_purge_result_time => NULL,    credential_purge_result_scope => NULL,    credential_purge_result_type => NULL,    credential_purge_result_format => NULL,    credential_purge_result_display => NULL,    credential_purge_result_threshold => NULL,    credential_purge_result_policy => NULL,    credential_purge_result_action => NULL,    credential_purge_result_count => NULL,    credential_purge_result_interval => NULL,    credential_purge_result_time => NULL,    credential_purge_result_scope => NULL,    credential_purge_result_type => NULL,    credential_purge_result_format => NULL,    credential_purge_result_display => NULL,    credential_purge_result_threshold => NULL,    credential_purge_result_policy => NULL,    credential_purge_result_action => NULL,    credential_purge_result_count => NULL,    credential_purge_result_interval => NULL,    credential_purge_result_time => NULL,    credential_purge_result_scope => NULL,    credential_purge_result_type => NULL,    credential_purge_result_format => NULL,    credential_purge_result_display => NULL,    credential_purge_result_threshold => NULL,    credential_purge_result_policy => NULL,    credential_purge_result_action => NULL,    credential_purge_result_count => NULL,    credential_purge_result_interval => NULL,    credential_purge_result_time => NULL,    credential_purge_result_scope => NULL,    credential_purge_result_type => NULL,    credential_purge_result_format => NULL,    credential_purge_result_display => NULL,    credential_purge_result_threshold => NULL,    credential_purge_result_policy => NULL,    credential_purge_result_action => NULL,    credential_purge_result_count => NULL,    credential_purge_result_interval => NULL,    credential_purge_result_time => NULL,    credential_purge_result_scope => NULL,    credential_purge_result_type => NULL,    credential_purge_result_format => NULL,    credential_purge_result_display => NULL,    credential_purge_result_threshold => NULL,    credential_purge_result_policy => NULL,    credential_purge_result_action => NULL,    credential_purge_result_count => NULL,    credential_purge_result_interval => NULL,    credential_purge_result_time => NULL,    credential_purge_result_scope => NULL,    credential_purge_result_type => NULL,    credential_purge_result_format => NULL,    credential_purge_result_display => NULL,    credential_purge_result_threshold => NULL,    credential_purge_result_policy => NULL,    credential_purge_result_action => NULL,    credential_purge_result_count => NULL,    credential_purge_result_interval => NULL,    credential_purge_result_time => NULL,    credential_purge_result_scope => NULL,    credential_purge_result_type => NULL,    credential_purge_result_format => NULL,    credential_purge_result_display => NULL,    credential_purge_result_threshold => NULL,    credential_purge_result_policy => NULL,    credential_purge_result_action => NULL,    credential_purge_result_count => NULL,    credential_purge_result_interval => NULL,    credential_purge_result_time => NULL,    credential_purge_result_scope => NULL,    credential_purge_result_type => NULL,    credential_purge_result_format => NULL,    credential_purge_result_display => NULL,    credential_purge_result_threshold => NULL,    credential_purge_result_policy => NULL,    credential_purge_result_action => NULL,    credential_purge_result_count => NULL,    credential_purge_result_interval => NULL,    credential_purge_result_time => NULL,    credential_purge_result_scope => NULL,    credential_purge_result_type => NULL,    credential_purge_result_format => NULL,    credential_purge_result_display => NULL,    credential_purge_result_threshold => NULL,    credential_purge_result_policy => NULL,    credential_purge_result_action => NULL,    credential_purge_result_count => NULL,    credential_purge_result_interval => NULL,    credential_purge_result_time => NULL,    credential_purge_result_scope => NULL,    credential_purge_result_type => NULL,    credential_purge_result_format => NULL,    credential_purge_result_display =>