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.

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 AI Database 26ai or later. For older version models that were imported into Oracle AI Database 26ai or later, the value of this column is null.
COMMENTS VARCHAR2(4000)   Comment applied to the model with a SQL COMMENT statement
EXTERNAL_DATAFoot 1 VARCHAR2(3)  

If ALGORITHM = ONNX, this column indicates whether the ONNX model can be in-memory enabled (YES) or not (NO).

Otherwise, the value of this column is meaningles and is set to NO.

INMEMORYFoot 1 VARCHAR2(3)  

If ALGORITHM = ONNX and EXTERNAL_DATA = YES, this column indicates whether the ONNX model is in-memory enabled (YES) or not (NO)

Otherwise, the value of this column is meaningless and is set to NO.

Footnote 1 This column is available starting with Oracle AI Database 26ai, Release Update 23.26.1.