Re: Importing on Linux is SO SLOW.

Charles,

if you set COMMIT=Y then Oracle commmits after every buffer load, rather than a single commit at the very end. If you have a lot of data to import, then you better have a large rollback as well if you don't have commit=y.
I use buffer=1024000 on my HP servers and my NT boxes and this gives a decent performace.
Another thing that troubles me, why did the other import fail with no room in system tablespace ?
If it was for stored procs, packages etc then fine - make it bigger, but if your users have their default tablespace set to system then you are about to be in deep trouble, and your performance will suffer as a result.

Check with :

select username
from dba_users
where default_tablespace = 'SYSTEM'
or temporary_tablespace = 'SYSTEM';

If you get more than SYS/SYSTEM then your database in not correctly set up.

I tend to make SYS have the SYSTEM tablespace as its default, and put SYSTEM into the TOOLS tablespace.
I also create a TEMP tablespace (and make sure it is temporary) and set every user's temporat_tablespace to TEMP.

If your TEMP tablespace is not really a temporary one, then any segments created in it will have to be recored in the dictionary, and when done with, deleted from the dictionary. This will have quite a serious effect on general performance.

HTH. Regards,
Norman.

Norman Dunbar			EMail:	Norman.Dunbar_at_LFS.co.uk
Database/Unix administrator	Phone:	0113 289 6265
				Fax:	0113 289 3146
Lynx Financial Systems Ltd.	URL:	http://www.Lynx-FS.com


------------------------------------------------------------------------