3.310 ALL_MINING_MODELS

ALL_MINING_MODELS describes the machine learning models accessible to the current user.

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

Related Views

  • DBA_MINING_MODELS describes all machine learning models in the database.

  • USER_MINING_MODELS describes 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

MINING_FUNCTION

VARCHAR2(30)

  

Function of the mining model. The function identifies the class of problems that can be solved by this model. The machine learning function is specified when the model is built:

  • CLASSIFICATION

  • REGRESSION

  • CLUSTERING

  • EMBEDDING

  • FEATURE_EXTRACTION

  • ASSOCIATION_RULES

  • ATTRIBUTE_IMPORTANCE

  • TIME_SERIES

ALGORITHM

VARCHAR2(30)

  

Algorithm used by the model. Each machine learning function has a default algorithm. The default can be overridden with a model setting (see *_MINING_MODEL_SETTINGS):

  • APRIORI_ASSOCIATION_RULES

  • CUR_DECOMPOSITION

  • DECISION_TREE

  • EXPECTATION_MAXIMIZATION

  • EXPLICIT_SEMANTIC_ANALYS

  • EXPONENTIAL_SMOOTHING

  • EXTENSIBLE_LANG

  • GENERALIZED_LINEAR_MODEL

  • KMEANS

  • MINIMUM_DESCRIPTION_LENGTH

  • MSET_SPRT

  • NAIVE_BAYES

  • NEURAL_NETWORK

  • NONNEGATIVE_MATRIX_FACTOR

  • O_CLUSTER

  • ONNX

  • RANDOM_FOREST

  • SUPPORT_VECTOR_MACHINE

  • SINGULAR_VALUE_DECOMP

  • XGBOOST

ALGORITHM_TYPE

VARCHAR2(10)

  

R type algorithm. This column is used in R algorithm registration.

CREATION_DATE

DATE

NOT NULL

Date that the model was created

BUILD_DURATION

NUMBER

  

Time (in seconds) of the model build process

MODEL_SIZE

NUMBER

  

Size of the model (in megabytes)

PARTITIONED

VARCHAR2(3)

  

Indicates whether the model is partitioned or not. Possible values:

  • YES: The model is partitioned.

  • NO: The model is not partitioned

BUILD_SOURCE

CLOB

  

Input data source (provided by the user at build time) on which to build the model

This column is populated for models created in Oracle Database 23ai or later. For older version models that were imported into Oracle Database 23ai or later, the value of this column is null.

COMMENTS

VARCHAR2(4000)

  

Comment applied to the model with a SQL COMMENT statement