ora 4030 - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 17 of 17

Thread: ora 4030

  1. #11
    Join Date
    Mar 2002
    Location
    Mesa, Arizona
    Posts
    1,204
    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 do not fear computers. I fear the lack of them." Isaac Asimov
    Oracle Scirpts DBA's need

  2. #12
    Join Date
    Feb 2000
    Location
    NJ, United States
    Posts
    250
    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

  3. #13
    Join Date
    Mar 2002
    Location
    Mesa, Arizona
    Posts
    1,204
    Best of luck...
    "I do not fear computers. I fear the lack of them." Isaac Asimov
    Oracle Scirpts DBA's need

  4. #14
    Join Date
    Feb 2000
    Location
    NJ, United States
    Posts
    250
    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

  5. #15
    Join Date
    Mar 2002
    Location
    Mesa, Arizona
    Posts
    1,204
    Just curious, how do you know your per session memory is > 900M?
    "I do not fear computers. I fear the lack of them." Isaac Asimov
    Oracle Scirpts DBA's need

  6. #16
    Join Date
    Feb 2000
    Location
    NJ, United States
    Posts
    250
    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

  7. #17
    Join Date
    Mar 2002
    Location
    Mesa, Arizona
    Posts
    1,204
    That is just massive.
    "I do not fear computers. I fear the lack of them." Isaac Asimov
    Oracle Scirpts DBA's need

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width