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:
ALL_MINING_MODEL_SETTINGS
in Oracle Database Reference