When you run parallel insert through SQL*LOADER, Oracle creates as many extents equal to the parallel processes. If the number of parallel processes is 5, then 5 extents will be created in the tablespace for the table to start with. Then extents will be added once a extent is filled. And finally when the job is done, the free space in the last extents of each parallel proces is freed. The last extent size may be equal to initial or next extent size even though pctincrease is set to 0. This leads to unequal extent sizes within the tablespace.

To over come this flaw, you need to set the event 10901 at the system level before you start laoding data into the table.



[Edited by tamilselvan on 02-13-2002 at 11:34 AM]