This content has been marked as final. Show 3 replies
1) Of course this is a possibility. It is up to you to know whether your table fits what is described in the documentation (you copied that text from http://download.oracle.com/docs/cd/E14072_01/server.112/e10837/parallel.htm#VLDBG1531, didn't you?). Note that there are other situations that lead to a serial execution... e.g. triggers, foreign keys and object columns.
2) If the condition specified in the documentation is met, recreating the table should fix it. I do not see how PCTFREE and INITRANS might help.
3) With a PDML you want to have a single process working on a block. Hence, it's not necessary to have several ITLs.
Troubleshooting Oracle Performance, Apress 2008
Edited by: Chris Antognini on Jul 22, 2011 9:52 PM
Thanks for the clarification.
I had read the documentation but failed to grasp the source of itl variant property, and its definition.
But at least I understand and accept that from 9.0.1 this property is set by default.
Thanks for your clear and precise anwser.
It was clear and precise,
Thx for your feedback