Re: ORA-04031 SGA error !! HELP!!
From: <fff_at_ddd.net>
Date: 1996/02/27
Message-ID: <4gtui0$7mh_at_news2.ios.com>#1/1
Date: 1996/02/27
Message-ID: <4gtui0$7mh_at_news2.ios.com>#1/1
In article <Pine.SUN.3.91.960226094556.2163G-100000_at_seatimes>, Steve Butler <sbut-is_at_seatimes.com> wrote:
>
>On 21 Feb 1996 root_at_.MISSING-HOST-NAME. wrote:
>> ORA-04031 Unable to allocate 744 bytes of shared
>> memory("unknown object","sga heap","library cache")>!
>>
>> How can I configure it to avoid above error ?
>
>Upgrade to the latest release when it comes out.
>
>In the meantime, you have the following options:
>
>1. Do an ALTER SYSTEM FLUSH SHARED_POOL;
>or
>2. SHUTDOWN and STARTUP the database;
skiped
Had the very same message
>> >ORA-04031 Unable to allocate 744 bytes of shared
>>> memory
when mispelled CURRVAL as "CURVAL"
Dave
Received on Tue Feb 27 1996 - 00:00:00 CET