Re: BULK Processing Process "Expires" without completing

From: Dereck L. Dietz <>
Date: Mon, 21 Jan 2008 16:27:07 GMT
Message-ID: <vJ3lj.8407$>

> Try looking at v$sesstat from another session to see how much PGA you
> are soaking up.
> There used to be an old adage about assigning an empty plsql table was
> better at releasing memory then xxx.delete, but I've never really tested
> that hypothesis.

I'm using nested tables and for some reason I'm not able to get the syntax correct for assigning an empty table to a nested table.

> Can you not achieve the same with just plain old SQL, or maybe a
> pipeline function
> --
> Connor McDonald
> Co-author: "Mastering Oracle PL/SQL - Practical Solutions"
> Co-author: "Oracle Insight - Tales of the OakTable"
> web:
> web:
> email:
> "Semper in excremento, sole profundum qui variat."
> ------------------------------------------------------------
Received on Mon Jan 21 2008 - 10:27:07 CST

Original text of this message