dear experts,
would be nice to hear if someone has already used the new init ORA-Paramter PARALLEL_DEGREE_POLICY
wich controls the "In-Memory Parallel Execution".
Before Oracle 11gr2 parallel processing by-passed the database buffer cache for most operations, reading data directly from disk . Now a check is conducted to determine if the objects accessed by the statement should be cached in the aggregated buffer cache of the system and later may reused .
The memory capacity on a typical database server have become extremely large.So, using the buffer cache to hold large object doesn't seem so impossible any more.
In-Memory PX initialization parameter PARALLEL_DEGREE_POLICY must be set to AUTO (default MANUAL)
I assume it can speed up parallel DB operations i.e. like ODS-activation or Bitmap Index creation...you name it.
Is SAP valuating that paramter for a standard setting in it's SAP BW system running 11gr2 ?
bye
yk