I'm running several workflow on sqldeveloper data miner tools to create my model. My Data is around 3 million rows, to monitor the process I look to oracle enterprise manager.
From what I've seen in oracle enterprise manage most of process ODM from my modelling didn't get parallel and sometimes my process not finished more than a day.
Any tips/suggestion how we can improve ODM Process Performance ? By enable parallelism on each process/query maybe ?
Ensure that any input table used in modeling or scoring has a PARALLEL attribute set properly. Since minig algorithms are usually CPU bound try to utilize whatevet CPU power you have. Following might be a good starting point:
ALTER TABLE myminingtable PARALLEL <Number of Physical Cores on your Hardware>;