Messages ORA-04031: unable to allocate 672 bytes of shared memory

XMLWordPrintable

    • Type: Incident report
    • Resolution: Won't fix
    • Priority: Critical
    • None
    • Affects Version/s: None
    • Component/s: Server (S)
    • None
    • Environment:
      Red HAT Linux 2.6.18-164.el5 #1 SMP Tue Aug 18 15:51:48 EDT 2009 x86_64 x86_64 x86_64 GNU/Linux
      Oracle 11.2.0.2 enterprise edition

      Messages ORA-04031: unable to allocate 672 bytes of shared memory ("shared pool","unknown object","sga heap(1,1)","KGLHD")[/opt/zabbix/3rdp/apachesrv/htdocs/zabbix/include/db.inc.php:455]

      ZABBIX application to much fragment Oracle shared pool, so Oracle cannot allocate more memory for sga (set to 6 GB).

        1. pb sga.txt
          0.2 kB
          Dominique Benech
        2. show parameter sga.txt
          13 kB
          Dominique Benech

            Assignee:
            Unassigned
            Reporter:
            Dominique Benech
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved: