ora 4030

[KenEwald]

Can you just restart the machine? I know it sounds silly, but it's amazing how some of these (Oracle on Windows) problems just go away with a reboot ...

Maybe it's a memory fragmentation issue.

[Knarayan]

I cannot do that now probably I will try that tommorrow, yes i know lot of problems in windows just goes away by reboot..amazing

[KenEwald]

Best of luck...

[Knarayan]

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
--and value>10000000
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.
Any suggestions??

[KenEwald]

Just curious, how do you know your per session memory is > 900M?

[Knarayan]

If I understand it right the result I pasted from the sql is in bytes right so :
109 session pga memory max 1010846480
1010846480/1024*1024 comes to 964M
Am i right????

[KenEwald]

That is just massive.