我们在使用 oracle 9i 的 xmldb 工具编写大型 xml 文件时遇到了问题。查询生成大约 300 万行,oracle 响应以下错误消息:
ERROR at line 1:
ORA-04030: out of process memory when trying to allocate 4012 bytes
(qmxtgCreateBuf,kghsseg: kolaslCreateCtx)
ORA-06512: at "....", line 1154
ORA-06512: at line 1
ERROR:
ORA-00600: internal error code, arguments: [%s], [%s], [%s], [%s], [%s], [%s],
[%s], [%s]
在警报日志中:
Errors in file d:/db/admin/acc1/udump/acc1_ora_8112.trc:
ORA-00600: internal error code, arguments: [729], [104], [space leak], [], [], [], [], []
我们尝试增加进程内存,但这几乎没有任何效果。
有没有办法让预言机为xml使用更少的内存("懒惰表现"/直写开关或类似的东西?
您需要使用BULK
操作和LIMITED PAGED
查询
来管理进程消耗的内存例如:
DECLARE
CURSOR c_customer IS
SELECT CUSTOMER.id, CUSTOMER.name from CUSTOMER;
TYPE customer_array_type IS TABLE OF c_customer%ROWTYPE INDEX BY BINARY_INTEGER;
customer_array customer_array_type;
fetch_size NUMBER := 5000; -- scale the value to manage memory
BEGIN
-- Open(create) XML file
OPEN c_customer;
loop
FETCH c_customer BULK COLLECT
INTO customer_array LIMIT fetch_size;
FOR i IN 1 .. customer_array.COUNT LOOP
null; -- Add XML nodes
END LOOP;
EXIT WHEN c_customer%NOTFOUND;
END LOOP;
CLOSE c_customer;
-- Close(flush) XML file
End;
在某些情况下,当文件大小超过操作系统文件大小限制时,您必须创建多个文件。