Oracle import allocate memory until AIX crash ?!

From: Goin'n bold <jer_48_at_my-deja.com>
Date: Wed, 28 Jul 1999 11:57:36 GMT
Message-ID: <7nmr7d$oon$1@nnrp1.deja.com>

Hi !

When running imp on one of our large (tables containing more then 1.000.000 rows) databases in Oracle 8 runing on a AIX 4.x machine the machine crashes.

We started a monitoring program on the AIX server and found that it's eating up all virtual memory during import. Starting at ca: 128 MB of free memory it just start to allocate memory until it reaches 0 MB and crashes.

Has anyone had any experience with this ? is it working as designed ( and we need to buy more memory ) or is it a bug ?

If it's working as designed where can we restrict memory usage so the import can continue ( a bit slower due to less memory) without taking down the machine.

Looking at the imp parameters we have played around with BUFFER and COMMIT but the result is the same...

/TIA, Jer

--
Gandhi: An eye for an eye only ends up making the whole world blind.

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Wed Jul 28 1999 - 06:57:36 CDT