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
    May 2003
    Location
    France
    Posts
    112

    Re: Shared Memory Issue on Linux with Oracle

    Hi,

    query v$sgastat and check free_memory from shared pool and large_pool; if too small, increase shared_pool_size or/and large_pool_size

    hope this help you

    Originally posted by cbarone
    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

Posting Permissions

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