Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Posts
    13

    Unanswered: Shared Memory Issue on Linux with Oracle

    Setup

    Redhat Linux Enterprise 2.1
    Oracle 8.1.7
    Dual 2.2 PIV's
    2 Gig of Ram

    About twice a week we get a shared memory issue. Here is the error at the sqlplus prompt.

    ERROR:
    ORA-00604: error occurred at recursive SQL level 2
    ORA-04031: unable to allocate 4200 bytes of shared memory ("shared
    pool","TRIGGER$","sga heap","state objects")
    ORA-00604: error occurred at recursive SQL level 1
    ORA-04031: unable to allocate 4200 bytes of shared memory ("shared
    pool","unknown object","sga heap","state objects")

    Any quick fixes to possible correct this?

    Thanks,

    cbarone@dca.net

  2. #2
    Join Date
    Nov 2002
    Posts
    833
    increase the sga in your init.ora file rsp. spfile

Posting Permissions

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