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