I didn't get a chance to reboot the machine but I see that this goes through during the night as we have a application which compiles procedures during the night.
It is very funny, the sessions where I am trying to compile the changes to the procedure is trying to use more than 900M of memory, amazing and i am having this error in very instance, here is the pga max memory in these sessions trying to compile:
select sid, name, value
from v$statname n, v$sesstat s
where n.statistic# = s.statistic#
and n.name like '%memory%'
and sid =109
order by sid;
109 session pga memory max 1010846480
23 session pga memory max 1164893868
My problem is I don't have the right unwrapped version of this particular procedure..
i have already logged an itar with metalink for this problem waiting for their feedback.