on 04-07-2011 12:20 PM
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
Hello Mr. YK
As of now SAP is not recommending PARALLEL_DEGREE_POLICY to be set for Oracle 11g DB versions.
All approved parameters are defined in
SAP Note : 1431798 - Oracle 11.2.0: Database Parameter Settings
Hope it helps.
Regards
Venkat
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
78 | |
9 | |
9 | |
7 | |
7 | |
6 | |
6 | |
5 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.