-
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.
-
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
KN
-
-
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??
KN
-
Just curious, how do you know your per session memory is > 900M?
-
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????
KN
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|