import using imp 10.2.0.2 commits every row

i try to import a dump created by exp 10.2.0.1 with 10.2.0.2. import is running very slow (approx. 1100 rows with avglen=150 bytes per
second). the importing sessions shows a lot of log file sync wait events which
is strange because buffer is set to 2M. as a test i imported only one table
with 140 rows from the large dump file and checked the user commits for the
importing session: 145 commits.
i repeated the test with different tables with different number of rows, user
commits was every time equal to number of rows + 5. so it seems that imp
commits every row. if i import with commit=n i get 6 commits for 140-rows table
which is plausible. i can reproduce the problem on AIX and linux.

here are the commands:

$ exp userid=user file=dumpfile statistics=none owner=owner direct=n
$ imp userid=user file=dumpfile commit=y fromuser=owner
touser=new_owner statistics=none tables=table buffer=2000000

TAR is opened but i would like to get a confirmation if possible. anyone?

regards,
-j Received on Wed Jun 21 2006 - 12:03:10 CDT