Re: Shared Pool Size and ORA-4031

Monitor your v$sgastat, particularly where name = 'free memory' which shows the free memory you have in the shared pool. ALTER SYSTEM FLUSH SHARED_POOL does regain the free memory, but it hurts performance. I will not flush my database regularly.

-- 
====================================================
|  Simon C. Leung             | Disclaimer:        |
|  Oracle Corporation         | my opinions only,  |
|  scleung_at_us.oracle.com      | not my employer's. |
====================================================


Parris Geiser wrote:


> 

> 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:

> >       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