ALL_STAT_EXTENSIONS

Previous Next JavaScript must be enabled to correctly display this content

3.85 ALL_STAT_EXTENSIONS

ALL_STAT_EXTENSIONS displays information about the optimizer statistics extensions accessible to the current user.

Related Views

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(128)`	`NOT NULL`	Owner of the extension
`TABLE_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the table to which the extension belongs
`EXTENSION_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the statistics extension
`EXTENSION`	`CLOB`		Extension (the expression or column group)
`CREATOR`	`VARCHAR2(6)`		Creator of the extension: `USER` `SYSTEM`
`DROPPABLE`	`VARCHAR2(3)`		Indicates whether the extension is droppable using `DBMS_STATS.DROP_EXTENDED_STATS` (`YES`) or not (`NO`)

See Also:

"DBA_STAT_EXTENSIONS"
"USER_STAT_EXTENSIONS"
Oracle Database PL/SQL Packages and Types Reference for more information about the DBMS_STATS.DROP_EXTENDED_STATS procedure