ORA-04031

From: Kevin Seneviratne <kevins_at_connect.com.au>
Date: Mon, 29 Jun 1998 17:22:50 +1000
Message-ID: <359740C9.7832927A@connect.com.au>

Dear All
I am running Oracle 7.2.3 and keep getting the intermittent error ORA-04031 "Unable to allocate 740 kb of SGA ....." when trying to insert records through SQL*PLUS. The error is totally random - in that sometimes a 1000 record insert work other times it trigger the error.
Increasing the SGA size has had no effect on this. What is even stranger is that no error is recorded in the alert file

Many thanks in advance for help

Kevin. Received on Mon Jun 29 1998 - 02:22:50 CDT