Re: bulk collect memory leak

have you requested assistance from oracle support with this particular issue ?

the error message you got was "out of memory error" ? with no oracle error message id ?
any entry in the alert log ?
any trace files in bdump or udump directories ?

one possible workaround i would suggest would be to avoid using the BULK COLLECT syntax.

"Aleksey Kochetov" <kochetov_at_optonline.net> wrote in message news:92hP6.56673$MR1.8328698_at_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 - 21:02:06 CDT