用的是oracle 的快照技术,在做复制的内存不断消耗,内存到53%时,提示错误如下:Error at line 1:
ORA-04030: out of process memory when trying to allocate 65036 byte (callheap,KQL,ternbuf)
ORA-06508: PL/SQL : could not find program unit being called
ORA-06512:at “sys.DBMS_SNAPSHOT”,line 578
ORA-04030: out of process memory when trying to allocate 52356 byte(pgeheap,ksm,stack)
ORA-04030: out of process memory when trying to allocate 65036 byte(callheap,KQL,ternbuf)
ORA-06508: PL/SQL : could not find program unit being called
ORA-06512:at “sys.DBMS_SNAPSHOT”,line 863
ORA-04030: out of process memory when trying to allocate 65036 byte (koh durheap d,kol vstring)
ORA-01632: Max # extents(20) reached in index ops$CYXT.DBDSNAP$_DFD_HZ_NO_PK
ORA-06512:preceding line from XHSD
ORA-06512: at “sys.DBMS_SNAPSHOT”,line644
OIRA-06512:at “sys.DBMS_2REFRESH” line 561
ORA-06512:at “sys.BDMS_REFRESH” line 207
ORA-06512: at line 1如何处理??以前我是把快照表drop掉。
ORA-04030: out of process memory when trying to allocate 65036 byte (callheap,KQL,ternbuf)
ORA-06508: PL/SQL : could not find program unit being called
ORA-06512:at “sys.DBMS_SNAPSHOT”,line 578
ORA-04030: out of process memory when trying to allocate 52356 byte(pgeheap,ksm,stack)
ORA-04030: out of process memory when trying to allocate 65036 byte(callheap,KQL,ternbuf)
ORA-06508: PL/SQL : could not find program unit being called
ORA-06512:at “sys.DBMS_SNAPSHOT”,line 863
ORA-04030: out of process memory when trying to allocate 65036 byte (koh durheap d,kol vstring)
ORA-01632: Max # extents(20) reached in index ops$CYXT.DBDSNAP$_DFD_HZ_NO_PK
ORA-06512:preceding line from XHSD
ORA-06512: at “sys.DBMS_SNAPSHOT”,line644
OIRA-06512:at “sys.DBMS_2REFRESH” line 561
ORA-06512:at “sys.BDMS_REFRESH” line 207
ORA-06512: at line 1如何处理??以前我是把快照表drop掉。
解决方案 »
- oracle服务已启动怎么还找不到监听?
- 哪位知道oracle9i的net configuration assistant中测试连通与否的提示信息保存在什么文件里?
- 求sql语句
- 求一 SQL 语句
- 请教大家一个问题,当前的前100天到当前,用sql语句的时候日期范围怎么表达?
- da.khbh=kh.khbh(+) 这个(+)是什么意思啊
- 请问oracle数据库中哪张表里记录数据库所有表的表名,那张表记录各个表的主键?
- 在oem里新建了個User,要給他設名權限就能用OEM連DB.
- SVRMGR的问题,急
- 关于Dblink和视图结合,查询数据的疑问
- 有個難度很高的問題 有誰能幫我 給60點
- 急、急、急
把数据库的参数调整大一些
我认为还是要增大shared_pool_size的大小