[Home] [Help]
[Dependency Information]
Object Name: | USER_OUTLINES |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Stored outlines owned by the user
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
NAME | VARCHAR2 | (128) | Name of the outline | |
CATEGORY | VARCHAR2 | (128) | Category to which the outline belongs | |
USED | VARCHAR2 | (6) | Flag indicating whether the outline has ever been used | |
TIMESTAMP | DATE | Timestamp at which the outline was created | ||
VERSION | VARCHAR2 | (64) | Oracle Version that created the outline | |
SQL_TEXT | LONG | (0) | SQL text of the query | |
SIGNATURE | RAW | (16) | Signature uniquely identifying the outline SQL text | |
COMPATIBLE | VARCHAR2 | (12) | Flag indicating whether the outline hints were compatible across migration | |
ENABLED | VARCHAR2 | (8) | Flag indicating whether the outline is enabled | |
FORMAT | VARCHAR2 | (6) | Flag indicating what hint format is used | |
MIGRATED | VARCHAR2 | (12) | Flag indicating whether the outline has been migrated to SQL plan baseline |
Cut, paste (and edit) the following text to query this object:
SELECT NAME
, CATEGORY
, USED
, TIMESTAMP
, VERSION
, SQL_TEXT
, SIGNATURE
, COMPATIBLE
, ENABLED
, FORMAT
, MIGRATED
FROM SYS.USER_OUTLINES;
|
|
|