Shared Pool Size and ORA-4031

        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