ALL_STAT_EXTENSIONS displays information about the optimizer statistics extensions accessible to the current user.
DBA_STAT_EXTENSIONS displays information about all optimizer statistics extensions in the database.
USER_STAT_EXTENSIONS displays information about the optimizer statistics extensions owned by the current user. This view does not display the OWNER column.
| Column | Datatype | NULL | Description |
|---|---|---|---|
OWNER |
VARCHAR2(30) |
NOT NULL |
Owner of the extension |
TABLE_NAME |
VARCHAR2(30) |
NOT NULL |
Name of the table to which the extension belongs |
EXTENSION_NAME |
VARCHAR2(30) |
NOT NULL |
Name of the statistics extension |
EXTENSION |
CLOB |
Extension (the expression or column group) | |
CREATOR |
VARCHAR2(6) |
Creator of the extension:
|
|
DROPPABLE |
VARCHAR2(3) |
Indicates whether the extension is droppable using DBMS_STATS.DROP_EXTENDED_STATS (YES) or not (NO) |
See Also: