Can't enable Parallel Creation
I have tried to limit the parallel processes before that SAP Predictive Analytics creates in background of the Oracle Database when building models. I have limited the parallel process from db side by restricting the spesific database user which SAP Predictive Analytics uses when connecting via ODBC.
I know that parallel process is enabled by default in SAP Predictive Analytics. Now even though I have deleted all the configurations from
files. There is only one process is active on database. I can't enable parallel process.
I have changed the configurations and restarted Automated Analytics service and also restarted Windows server. Is there a point that I could be missing ?
I really grateful for any comments,
Abdel DADOUCHE replied
Can you clarify a little mode the context?
I will assume that you are using Automated Analytics.
There are two steps when data are accessed from your database:
- learning: the data is retrieved and cached in the data cache
- apply: when scoring there are two options:
- in database scoring: the scoring SQL is send for execution to the database (no data movement
- the data is retrieved, scored row by row in the Automated Analytics process then sent back to the database
Can you tell me which case you are in?
There several options in Automated Analytics that relates to parallel execution on Oracle.
The first one relates to the way we create tables which can be enabled using the following config as an example:
ODBCStoreSQLMapper.MyODBCDSN.OracleParallelClause=PARALLEL(DEGREE 4 INSTANCES 2)
Now if you are refering to SQL execution only you can alter the session to force parallel execution using:
ODBCStoreSQLMapper.MyODBCDSN.SQLOnConnect1="ALTER SESSION FORCE PARALLEL DDL PARALLEL 5"
These changes doesn't requires the Automated Analytics to be restarted, but just the current session.