Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2003
    Location
    Hong Kong
    Posts
    56

    Arrow Unanswered: ORA-04030: out of process memory

    Hi all,

    I received the following error after running a long query(several joins on tables across different database) for more than 6 hours.

    ORA-04030: out of process memory when trying to allocate 32 bytes (callheap,qerrmbv[]: qerrmObnd)
    The query failed but I have no idea how to fix it. Could someone pls kindly give me advice?

    Thanks.
    Cheers,
    Shev

  2. #2
    Join Date
    Oct 2003
    Posts
    26

    Re: ORA-04030: out of process memory

    Hi,

    Have you tried increasing the shared pool size ? Other wise try to pin the large packages

    Arvind

  3. #3
    Join Date
    Nov 2003
    Location
    Bangalore, INDIA
    Posts
    333

    Thumbs up Re: ORA-04030: out of process memory

    Hi,

    I too encountered the same problem. Since the Query involves too many Joins on table across different database, data retrieval might be the problem. Try using rownum =1 or rownum<10 in the WHERE Clause. This restricts the Rows returned . So U might get the output.
    SATHISH .

Posting Permissions

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