Oracle 视图 ALL_STAT_EXTENSIONS 官方解释,作用,如何使用详细说明
本站中文解释
`ALL_STAT_EXTENSIONS`是一个视图,用于查询拥有指定统计信息扩展名称的Oracle用户的完整表、列和索引对象列表;它不仅可以识别出它自身是如何构建的,还可以识别出统计信息扩展名称是如何被映射到Oracle表中的,从而加以利用。
使用该视图,可以通过库级统一分发/收集或者表级收集统计信息;可以在查询中加上EXT_NAME (扩展名名称)参数;允许通过扩展名来识别不同的表、列和索引对象;可以用来查找拥有特定统计扩展的对象的基础信息,以便更好地更新进行性能分析或优化工作。
官方英文解释
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 theOWNER
column.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Owner of the extension |
|
|
|
Name of the table to which the extension belongs |
|
|
|
Name of the statistics extension |
|
|
Extension (the expression or column group) |
|
|
|
Creator of the extension:
|
|
|
|
Indicates whether the extension is droppable using |
See Also:
-
“DBA_STAT_EXTENSIONS”
-
“USER_STAT_EXTENSIONS”
-
Oracle Database PL/SQL
Packages and Types Reference for more information about theDBMS_STATS.DROP_EXTENDED_STATS
procedure