DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Ora-04030

  1. 06-29-2007, 10:06 AM #1
    ferex
    ferex is offline Junior Member
    Join Date
    Jun 2007
    Location
    Germany
    Posts
    4

    Ora-04030

    Hi,
    i have a problem with my 10.2.0.1 Database on Windows 2003 Server SP1.

    nested exception is java.sql.SQLException: ORA-04030: Zu wenig Prozessspeicher für Versuch xxxxx Bytes zuzuweisen (QERHJ hash-joi,kllcqas:kllsltba)

    What is the best solution method?

    Thanks
    Reply With Quote Reply With Quote
  2. 06-29-2007, 10:10 AM #2
    PAVB's Avatar
    PAVB
    PAVB is offline Senior Advisor
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,555
    have you conducted a search on this forum looking for "ORA-04030"?

    There are 49 threads about it.
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
    Reply With Quote Reply With Quote
  3. 06-29-2007, 10:37 AM #3
    ferex
    ferex is offline Junior Member
    Join Date
    Jun 2007
    Location
    Germany
    Posts
    4
    yes i searched in the forum and confused about it.
    i only found 19 threads

    "change parameter SGA and/or PGA" or ....

    I do not want to change blindly any parameters
    can you post me the link to the entry?
    Reply With Quote Reply With Quote
  4. 06-29-2007, 10:51 AM #4
    PAVB's Avatar
    PAVB
    PAVB is offline Senior Advisor
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,555
    Metalink Note #233869.1 -Diagnosing and Resolving ORA-4030 errors
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
    Reply With Quote Reply With Quote
  5. 06-29-2007, 12:17 PM #5
    ferex
    ferex is offline Junior Member
    Join Date
    Jun 2007
    Location
    Germany
    Posts
    4
    for testing i changed the pga_aggregate_target on the init.ora file on a refference machine/DB to 10 MB.
    (orginal was 450 MB)

    I am wrong or should get I not then also an error there?!

    aggregate PGA target was 10 MB, but "total PGA inuse" and "total PGA allocated" was over 10MB
    Reply With Quote Reply With Quote
  6. 07-02-2007, 02:44 AM #6
    ferex
    ferex is offline Junior Member
    Join Date
    Jun 2007
    Location
    Germany
    Posts
    4
    Hey PAVB,
    the /3G resolution is sadly no way in my eyes.
    Is there a option to limit something?

    Thanks
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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