Results 1 to 2 of 2

Thread: ORA-04030 error

  1. #1
    Join Date
    Jan 2010
    Posts
    72

    Unanswered: ORA-04030 error

    Hi,

    I got the below error when one of the scheduled job is running.
    --------------------------------------------------------------
    ORA-04030: out of process memory when trying to allocate 160280 bytes
    --------------------------------------------------------------

    I verified the table space and PGA. There is enough space available. So reran the job and job ran successfully though I didn't do any changes.

    Does any of you have an idea why I got this error and it is related to what?

    Please revert me at your earliest convenience.

    Regards,
    Regtha

  2. #2
    Join Date
    Jun 2004
    Posts
    796
    Provided Answers: 1
    When the job that failed was running what else was running on your server? Looks like whatever it was it was taking up enough RAM to cause problems for your job.
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

Posting Permissions

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