Re: ORA-04031 with one user under NT

From: sysdba <sysdba_at_inter.net.il>
Date: Tue, 5 Oct 1999 16:37:47 +0200
Message-ID: <7td21k$qpr$1@news2.inter.net.il>

use the command
"alter system flush shared_pool" from sqlplus connected to system, and also if it was'nt helpfull, try increase the shared_pool_size parameter in your init.ora file to
something like 100m, and then restart your database.

Asaf Shoval,

Oracle Israel Support Center.

Tim Romano <tim_at_ot.com> wrote in message news:rvhrp962mom69_at_corp.supernews.com...
> Although the initxxxx.ora file is using the #Intermediary settings, and
> although there is only one (1) user logged in, and the server has 1GB RAM,
> we're getting an intermittent ORA-04031 ("unable to allocate 228 bytes
of
> shared memory...") errors. The NT server on which this Oracle 7.3.4
> Workgroup database is installed recently underwent a service pack upgrade
> (to SP5). Are there any known issues with NT SP5 and 7.3.4? What else
> should we look at?
> TIA
>
> --
> --
>
>
>
>
Received on Tue Oct 05 1999 - 09:37:47 CDT