Memory configuration for Sun/Solaris 2.7 with Oracle 8.1.6.2

I am having some problems when I try to import an export file that is only 95mb in size. I am running on a Sun 450 with 2 gb on memory. I have 4 instances of Oracle (all 8.1.6.2). 3 instances have full exports of 95 mb, and the other one has an export of 232 mb.

Here is my /etc/system file:

set shmsys:shminfo_shmmax=4294967295
set shmsys:shminfo_shmmin=1
set shmsys:shminfo_shmmni=200
set shmsys:shminfo_shmseg=20
set semsys:seminfo_semmni=200
set semsys:seminfo_semmsl=1680
set semsys:seminfo_semmns=880
set semsys:seminfo_semopm=200
set semsys:seminfo_semvmx=32767

Does anyone have any good suggestions on how to best configure Oracle to use the memory most efficiently?

Thanks,

John Received on Thu Aug 16 2001 - 12:50:31 CDT