Re: Shared Pool Size and ORA-4031
From: Parris Geiser <parris_at_walleye.esp.bellcore.com>
Date: 1996/08/22
Message-ID: <4vhqvj$mdg_at_athos.cc.bellcore.com>#1/1
> (Out of space in shared pool size).
Date: 1996/08/22
Message-ID: <4vhqvj$mdg_at_athos.cc.bellcore.com>#1/1
Luis,
I am also getting this error, but for a different reason. We attempted to use dbms_utility.analyze_schema and boom, 4031! Increasing the shared pool size didn't seem to help. I don't understand the relationship between the analyze and shared pool. By the way, this is ORACLE 7.1.6 on HPUX. parris geiser Luis Santos (lsantos_at_centroin.com.br) wrote:> Digital Alpha 1000 Server. We are receiving several errors ORA-4031
> Hello all,
> I'm a DBA for a Oracle 7.2.2 database based on a Digital Unix v3.2c
> (Out of space in shared pool size).
> This error occurs (as sayed by Oracle) because a large package or
> cursor cannot be allocated in the shared pool. This is due inexistance
> of a contiguous free memory area in the shared pool.
> Oracle recommends me to, frequently, run the command ALTER SYSTEM
> FLUSH SHARED_POOL, to avoid this problem. I'm runnig it each four
> hours.
> But I notice that my performance have decreased.
> Has nayone more tips about the problem?
> Please reply both newsgroup and my e-mail.
> Thanks,
> --
> Luis Santos
> Relacional Consultoria
> Rio de Janeiro - Brazil
Received on Thu Aug 22 1996 - 00:00:00 CEST