ORA - 04030

I've been getting this error for a long time. I used a patch from Oracle, but it still happens, only not as often. Has anyone had any similar experiences?

Ioannis

    EXECUTE search_be ('CUS',


                       '',

                       'BAB',


                       '',

                       '',

                       '',

                       '',

                       '',

                       '',

                       '',

                       NULL,
                       NULL,
                       24)
ORA-04045: errors during reco
mpilation/revalidation of ESF.SEARCH_BE
ORA-04030: out of process memory when trying to allocate 4120 bytes (cursor work he,s
ort area)
ORA-07324: smpall: malloc error while allocating pga.