6 Managing System Resources for Oracle Data Miner

This chapter provides information to help you optimize your system to support Oracle Data Miner.

• Oracle Data Miner Resource Management Overview
  You can effectively manage system resources for Oracle Data Miner by using features of Oracle Database and the options provided in Oracle Data Miner repository.
• Allocating Resources to Oracle Data Miner User Sessions
  You can use Database Resource Manager to create resource plans that allocate system resources for groups of sessions based on session attributes.
• Managing Model Builds
  The process of building mining models can consume significant system resources. You have the option to control the impact of model builds on overall system resources, by increasing or decreasing the value of MAX_NUM_THREADS repository property.
• Managing Workflow Execution
  Oracle Data Miner submits workflows to Oracle Database Scheduler for execution as Scheduler Jobs. Oracle Scheduler supports a variety of features that control how system resources are allocated. You can configure Oracle Scheduler to effectively manage a large pool of run requests.
• Managing Parallel Processing
  Oracle Data Miner workflows and views, and most Data Mining algorithms, can take advantage of parallel processing of queries when it is enabled in the database. Parameters in INIT.ORA control the behavior of parallel processing. By default parallelism is disabled (PARALLEL_DEGREE_POLICY=MANUAL).
• Summary of Oracle Data Miner Repository Properties for System Management
  A summary of the system management properties is available in the Oracle Data Miner repository.