用的是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掉。
把数据库的参数调整大一些
我认为还是要增大shared_pool_size的大小