Move table partition in parallel

  • From: "Alex Gorbachev" <gorbyx@xxxxxxxxx>
  • To: "Oracle-L Freelists" <oracle-l@xxxxxxxxxxxxx>
  • Date: Sat, 29 Apr 2006 15:01:32 +0200

Hi listers,

Perhaps, someone can explain this behavior. I move partition of a table using:
alter table <owner>.<table> move partition <partition> tablespace
<tablespace> parallel 8 nologging;

Oracle spawn 8 parallel processes that are doing selects in parallel.
However, there is only one process that writes to the temporary
segment which becomes partition segment later. This single process is
spending its time on db file sequential read. I would expect that
Oracle should spawn 8 processes to write to new partition (each
process writing to its own temporary segment using direct writes,
perhaps). Obviously, this is terribly slow.

Is there any way to really parallelize partition move operation?

Table is heap-organized and contains few BLOB columns if it maters.
There is a local index partition of which, of course, gets invalidated
after move.

TIA!

--
Best regards,
Alex Gorbachev
--
//www.freelists.org/webpage/oracle-l


Other related posts: