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: