Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2011
    Posts
    32

    Unanswered: ORA Errros after db_cache_size increase ?

    Hi All,

    We are getting

    ORA-12801
    ORA-04030
    ORA-12537

    in our Alert.log ,

    after we increase our

    db_cache_size From 12 GB to 22 GB

    Any other parameter need to take care

    while Changing db_cache_size increase

    My oracle release is SQL*Plus: Release 10.2.0.5.0 -
    Regards

  2. #2
    Join Date
    Jan 2011
    Posts
    32
    And My OS is


    HP-UX s96mbvp1 B.11.23 U ia64 2832061502 unlimited-user license

  3. #3
    Join Date
    Jan 2011
    Posts
    32
    Many ORA-04030 alerts appearing in the alert log

    since 2 hours


    Regards

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Code:
    bcm@bcm-laptop:~$ oerr ora 12801
    12801, 00000, "error signaled in parallel query server %s"
    // *Cause: A parallel query server reached an exception condition.
    // *Action: Check the following error message for the cause, and consult
    //          your error manual for the appropriate action.
    // *Comment: This error can be turned off with event 10397, in which
    //           case the server's actual error is signaled instead.
    bcm@bcm-laptop:~$ oerr ora 4030
    04030, 00000, "out of process memory when trying to allocate %s bytes (%s,%s)"
    // *Cause:  Operating system process private memory was exhausted.
    // *Action: 
    bcm@bcm-laptop:~$ oerr ora 12537
    12537, 00000, "TNS:connection closed"
    // *Cause: "End of file" condition has been reached; partner has disconnected.
    // *Action: None needed; this is an information message.
    >db_cache_size From 12 GB to 22 GB
    Consider making it smaller than 22GB
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

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