这是我见过业务量最小的Oracle系统

数据运维 2024-01-24 贤蛋大眼萌 手机阅读

     今天一个网友发了一个Oracle AWR报告给我，希望能给一些建议，说这套数据库还经常出现ORA-04031错误。这一下就引起了我的好奇。我们都知道在Oracle 11g之前的版本出现这个错误的概率还是比较高的；从11g版本开始，几乎很少见到这个错误了，一年恐怕都遇不到1次。话不多说，我们来看看这个网友提供的数据。

    ===============================
    End 4031 Diagnostic Information
    ===============================
    DDE: Problem Key 'ORA 4031' was flood controlled (0x6) (incident: 295061)
    ORA-04031: unable to allocate 4160 bytes of shared memory ("shared pool","unknown object","sga heap(1,0)","modification ")
    <br>
    *** 2024-01-23 17:51:20.538
    DDE: Problem Key 'ORA 4031' was flood controlled (0x6) (incident: 295062)
    ORA-04031: unable to allocate 4160 bytes of shared memory ("shared pool","unknown object","sga heap(1,0)","modification ")