Re: erro ORA-04031
Date: Thu, 15 May 2003 14:38:55 +0200
Message-ID: <1053001864.123149_at_news.thyssen.com>
<XX> schrieb im Newsbeitrag news:b9v0av$2gb1_at_rain.i-cable.com...
> Hi all,
>
> How can I solve error ORA-04031?
> I am using Oracle version 8.1.7.
> THX.
>
Hi Nameless,
why don't you do what the docs tell you?
From the Oracle 8i Error Messages Manual:
ORA-04031 unable to allocate string bytes of shared memory ("string","string","string","string")
Cause: More shared memory is needed than was allocated in the shared pool.
Action: If the shared pool is out of memory, either use the
DBMS_SHARED_POOL package to pin large packages, reduce your use
of shared memory, or increase the amount of available shared memory by
increasing the value of the initialization parameters
SHARED_POOL_RESERVED_SIZE and SHARED_POOL_SIZE. If the
large pool is out of memory, increase the initialization parameter
LARGE_POOL_SIZE.
Good luck,
Guido
Received on Thu May 15 2003 - 14:38:55 CEST