bulk collect memory leak

From: Aleksey Kochetov <kochetov_at_optonline.net>
Date: Thu, 24 May 2001 23:45:09 GMT
Message-ID: <92hP6.56673$MR1.8328698@news02.optonline.net>

Hi.
I use bulk collect in a stored procedure. I got out of memory error. I reproduced it for 8.1.6.2 (HP & Linux) and 8.1.7 (HP). Somebody knows? Does Oracle have a fix?

CREATE OR REPLACE PROCEDURE stress_test IS   TYPE strings IS TABLE OF VARCHAR2(1000)     INDEX BY BINARY_INTEGER;
  lv_dummy strings;
BEGIN
  FOR i IN 1..10 LOOP
    SELECT dummy BULK COLLECT INTO lv_dummy       FROM dual WHERE dummy IS NULL;
    lv_dummy.DELETE;
  END LOOP;
  lv_dummy.DELETE;
END stress_test;
/

BEGIN
  FOR i IN 1..10000 LOOP
    stress_test;
  END LOOP;
END;
/

SELECT * FROM v$sesstat t1, v$statname t2 WHERE name IN ('session uga memory','session pga memory') AND t1.statistic# = t2.statistic#
AND sid = 14; Received on Thu May 24 2001 - 18:45:09 CDT