欢迎访问 jiangxuyong 的个人空间

我的论坛主题

  • 9206数据库 ORA-04031

    2007-12-02 18:24:53   /   Oracle数据库管理

    oracle 9206操作系统:hp unix 11.11(1) 数据库因4031错重启过,2天后 miscellaneous涨到150M.上次出错时发现 miscellaneous 为300多M,不知道这块内存怎么一直再增加,具体出错信息如下:ORA-00604: error occurred at recursive SQL level 1ORA-04031: unable to allocate 4160 bytes of shared memory ("shared pool","unknown object","sga heap(2,0)","kglsim heap")(2)出错时查询sharedpool 内存情况:SQL> select ksmchidx,max(ksmchsiz),min(ksmchsiz),sum(ksmchsiz),count(*) from x$ksmsp where ksmchcls =

    查看(233) 评论(5)

我的资料

Open Toolbar