Re: Shared Pool Size and ORA-4031

From: Alex B. Danchenkov <dabr_at_leaves.spb.su>
Date: 1996/08/21
Message-ID: <321ABF06.7F9E_at_leaves.spb.su>#1/1


Luis Santos wrote:
>
> Hello all,
>
> I'm a DBA for a Oracle 7.2.2 database based on a Digital Unix v3.2c
> Digital Alpha 1000 Server. We are receiving several errors ORA-4031
> (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

Attempt to increase the value of SHARED_POOL_SIZE in the initialization parameter
file INIT%ORACLE_SID%.ORA. Then restart Oracle instance. Alex B. Danchenkov
Leaves Inc.
St Petersburg,Russia Received on Wed Aug 21 1996 - 00:00:00 CEST

Original text of this message