Re: ORA-04031

From: Venkat <vreddy_at_no_spamix.netcom.com>
Date: Mon, 29 Jun 1998 17:45:25 -0400
Message-ID: <6n91sg$9ai@sjx-ixn4.ix.netcom.com>

Kevin,
It means your shared pool is fragmented and 740 kb is not available in contiguous chunks. Investigate the SHARED_POOL_RESERVED_SIZE and SHARED_POOL_RESERVED_MIN_ALLOC parameters in init.ora. SHARED_POOL_RESERVED_SIZE reserves space in the shared pool for allocations larger than SHARED_POOL_RESERVED_MIN_ALLOC. Set the SHARED_POOL_RESERVED_SIZE to 10-20% of the shared pool size.

HTH
Venkat

>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 - 16:45:25 CDT