Re: bulk collect memory leak

I am a contracter and an official way is not short for me. "BULK COLLECT" is a great feature for performance improvement and i actually need it. About error messages:
HP: ORA-04030: out of process memory when trying to allocate 25520 bytes (callheap,bind var buf)
Linux (in alert_SID.log): ORA-00600: internal error code, arguments: [plio.c: non-reus], [1], [], [], [],..... and server crashed :)

"Spencer" <spencerp_at_swbell.net> wrote in message news:71jP6.139$ll2.6594_at_nnrp1.sbc.net...
> 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 - 22:47:44 CDT