Re: BULK Processing Process "Expires" without completing
Date: Mon, 21 Jan 2008 16:27:07 GMT
Message-ID: <vJ3lj.8407$pA7.308@newssvr25.news.prodigy.net>
> 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: http://www.oracledba.co.uk
> web: http://www.oaktable.net
> email: connor_mcdonald_at_yahoo.com
>
>
> "Semper in excremento, sole profundum qui variat."
>
> ------------------------------------------------------------
Received on Mon Jan 21 2008 - 10:27:07 CST