Oracle 视图 DBA_OUTLINES 官方解释，作用，如何使用详细说明
本站中文解释
Oracle视图DBA_OUTLINES主要用于查询和管理SQL操作的性能分析信息，包括定义出色的SQL目录及索引访问路径。
DBA_OUTLINES视图主要包含了如下信息：
1. OUTLINE_NAME：SQL目录的名称；
2. USER_NAME：定义此目录的用户名；
3. CATEGORY：定义目录的优化方法。
使用方法：
Oracle 允许用户使用CREATE OUTLINE 命令创建SQL操作的执行计划，或者使用ALTER OUTLINE 命令修改已存在的执行计划。使用DBA_OUTLINES视图可以获取这些执行计划的相关信息，以便于调整SQL的使用和提升数据库的性能。
官方英文解释
DBA_OUTLINES describes all stored outlines in the database.
Related View
USER_OUTLINES describes the stored outlines owned by the current user. This view does not display the OWNER column.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
User-specified or generated name of the stored outline. The name must be of a form that can be expressed in SQL. |
|
|
|
|
Name of the user who created the outline |
|
|
|
|
User-defined name of the category to which the outline belongs |
|
|
|
|
Indicates whether the outline has ever been used ( |
|
|
|
|
Timestamp of outline creation |
|
|
|
|
Oracle version that created the outline |
|
|
|
|
SQL text of the query, including any hints that were a part of the original statement. If bind variables are included, the variable names are stored as SQL text, not the values that are assigned to the variables. Note: This field may contain sensitive information about your database or application. Therefore, use discretion when granting |
|
|
|
|
Signature uniquely identifying the outline SQL text |
|
|
|
|
Indicates whether the outline hints were compatible across a migration ( |
|
|
|
|
Indicates whether the outline is enabled ( |
|
|
|
|
Hint format:
|
|
|
|
|
Indicates whether the outline has been migrated to a SQL plan baseline ( |
See Also:
“USER_OUTLINES”
