Oracle教程 2023-02-23

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

视图

ALL_MINING_MODEL_SETTINGS视图是Oracle数据挖掘（ODM）建模过程中的一个重要的信息源之一，主要用于提供有关数据挖掘模型的配置信息。该视图返回一条记录，每条记录代表一个数据挖掘模型的一个设置。这个视图的信息主要用于建模和调整数据挖掘模型的性能，包括预测模型和分类模型。

要使用此视图，首先需要指定模型ID参数，然后可以查询视图以获取配置信息：

SELECT * FROM ALL_MINING_MODEL_SETTINGS WHERE MODEL_ID = ;

其中是要查询的数据挖掘模型ID号。查询视图将返回模型中允许使用的调度信息、分析算法类型、缓存配置等等。

ALL_MINING_MODEL_SETTINGS describes the settings of the machine learning models accessible to the current user.

Machine learning models are schema objects created by Oracle Machine Learning for SQL.

Related Views

DBA_MINING_MODEL_SETTINGS describes the settings of all machine learning models in the database.
USER_MINING_MODEL_SETTINGS describes the settings of the machine learning models 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 machine learning model
`MODEL_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the machine learning model
`SETTING_NAME`	`VARCHAR2(30)`	`NOT NULL`	Name of the setting
`SETTING_VALUE`	`VARCHAR2(4000)`	–	Value of the setting
`SETTING_TYPE`	`VARCHAR2(7)`	–	Indicates whether the default value (`DEFAULT`) or a user-specified value (`INPUT`) is used by the model