USER_MINING_MODEL_SETTINGS

Example 2-3 describes USER_MINING_MODEL_SETTINGS and shows a sample query. Settings influence model behavior. Settings may be specific to an algorithm or to a mining function, or they may be general.

Example 2-3 USER_MINING_MODEL_SETTINGS

describe user_mining_model_settings
 Name                             Null?    Type
 -------------------------------- -------- ----------------------
 MODEL_NAME                       NOT NULL VARCHAR2(128)
 SETTING_NAME                     NOT NULL VARCHAR2(30)
 SETTING_VALUE                             VARCHAR2(4000)
 SETTING_TYPE                              VARCHAR2(7)

The following query returns the settings for a model named SVD_SH_SAMPLE in the user's schema. The model uses the Singular Value Decomposition algorithm for feature extraction.

SELECT model_name, setting_name, setting_value, setting_type
    FROM user_mining_model_settings
    WHERE model_name IN 'SVD_SH_SAMPLE'
    ORDER BY setting_name;
 
MODEL_NAME     SETTING_NAME                 SETTING_VALUE                SETTING
-------------- ---------------------------- ---------------------------- -------
SVD_SH_SAMPLE  ALGO_NAME                     ALGO_SINGULAR_VALUE_DECOMP  INPUT
SVD_SH_SAMPLE  FEAT_NUM_FEATURES             10                          DEFAULT
SVD_SH_SAMPLE  ODMS_APPROXIMATE_COMPUTATION  ODMS_APPR_COMP_DISABLE      DEFAULT
SVD_SH_SAMPLE  PREP_AUTO                     OFF                         DEFAULT
SVD_SH_SAMPLE  SVDS_SCORING_MODE             SVDS_SCORING_SVD            DEFAULT
SVD_SH_SAMPLE  SVDS_U_MATRIX_OUTPUT          SVDS_U_MATRIX_ENABLE        INPUT

See Also: