Oracle教程 2023-04-07

Oracle 视图 ALL_TAB_COL_STAT_MODELS 官方解释，作用，如何使用详细说明

ALL_TAB_COL_STAT_MODELS视图提供表和列统计模型的列表。每条记录表示一个统计模型，它被赋予一个用户或系统生成的唯一的编号。

使用ALL_TAB_COL_STAT_MODELS视图可以获取属于某个特定模型的所有统计信息。语法如下：

SELECT * FROM ALL_TAB_COL_STAT_MODELS
WHERE MODEL IN (SELECT MODEL FROM [USER_|ALL_]TAB_COL_STAT_MODELS
WHERE MODEL_NAME='[MODEL_NAME]’);

此查询可以用来查询具体模型并生成统计信息。通常，可以使用MODEL_NAME参数确定此模型。它可以是模型的完全限定名称，也可以是模型的名称（例如：WW1）。

ALL_TAB_COL_STAT_MODELS describes real-time statistics models for all tables accessible to the current user.

Real-time statistics models use machine learning algorithms to predict the number of distinct values (NDV) for table columns.

Related Views

DBA_TAB_COL_STAT_MODELS describes real-time statistics models for all tables in the database.
USER_TAB_COL_STAT_MODELS describes real-time statistics models for all tables 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 table
`TABLE_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the table
`COLUMN_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the table column to which the model applies
`STATS_TYPE`	`VARCHAR2(7)`		Statistics type The value of this column is always `NDV`.
`MODEL_NAME`	`VARCHAR2(200)`	`NOT NULL`	Name of the model
`STATUS`	`VARCHAR2(8)`		Status of the model (`ENABLED` or `DISABLED`)
`CREATED`	`TIMESTAMP(6) WITH TIME ZONE`		Time at which the model was created
`LAST_USED`	`TIMESTAMP(6) WITH TIME ZONE`		Time at which the model was most recently used

Note:

This view is available starting with Oracle Database 21c.