Hi i have installed ORACLE 8.1.6 on AIX 4.3.

it runs for a couple of days without any problem.

after that there are several processes created by oracle and it fills up the memory and i get the error that the os can not fork any more processes and Oracle does not respond.

i have created a user oracle on AIX which owns the software and is used to start and shutdown the database.

i am able to login as other users into AIX and do other operations.

i have checked with the O/S peoples and checked for the swapspace and processes for the user.the swap space is 4GB.

Can anyone guide me how to trace the error.

Right now when this happens i am going for a reboot of the box.