ALL_MINING_MODEL_SETTINGS

The following example describes ALL_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 ALL_MINING_MODEL_SETTINGS

 describe ALL_MINING_MODEL_SETTINGS
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 OWNER                                     NOT NULL VARCHAR2(128)
 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. The model uses the Singular Value Decomposition algorithm for feature extraction.

SELECT setting_name, setting_value, setting_type
    FROM all_mining_model_settings
    WHERE model_name = 'SVD_SH_SAMPLE'
    ORDER BY setting_name;

SETTING_NAME                   SETTING_VALUE                  SETTING           
------------------------------ ------------------------------ -------           
ALGO_NAME                      ALGO_SINGULAR_VALUE_DECOMP     INPUT             
ODMS_MISSING_VALUE_TREATMENT   ODMS_MISSING_VALUE_AUTO        DEFAULT           
ODMS_SAMPLING                  ODMS_SAMPLING_DISABLE          DEFAULT           
PREP_AUTO                      OFF                            INPUT             
SVDS_SCORING_MODE              SVDS_SCORING_SVD               DEFAULT           
SVDS_U_MATRIX_OUTPUT           SVDS_U_MATRIX_ENABLE           INPUT