Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Error ORA-04031: unable to allocate 288 bytes of shared memory
Make sure that your database has a large SGA. If possible, convert your code into a pl/sql package, and PIN it in the SGA. You can use ALTER SYSTEM FLUSH SHARED_POOL command to flush your Shared Pool, without shutting down your database.
-- Vijaya Kumar Vardhineni Oracle DBA, EDS Plano, TX Your Name <Yourname_at_somwhere.COM> wrote in article <5ar0kv$f41_at_Firewall.ttsl.co.uk>...Received on Tue Jan 07 1997 - 00:00:00 CST
> Hello,
>
> I have a problem that occurs sometimes, when trying a sql, PL/SQL or ProC
> program.
> It tells me it can not allocate a certain amount of memory, and then the
> process fails. This is probably due to fragmentation of the memory, so
> that the database has to be shut down.
>
> But my application runs on two sites: one uses oracle 7.0, the other one
> Oracle 7.2.
> The one with 7.2 has that problem every week, the other one never !!!!
>
> Does anybody else has that problem ?
> Is it due to Oracle 7,2, and if so, is it fixed with the 7.3 ??
> Thanks
> Renaud HUILLET
> rhuillet_at_ttsl.co.uk
>
>