Re: BULK Processing Process "Expires" without completing

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Tue, 22 Jan 2008 21:06:12 +0900
Message-ID: <4795DC34.A87@yahoo.com>


Dereck L. Dietz wrote:
>
> > 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."
> >
> > ------------------------------------------------------------

isn't it just:

my_nested_table := my_nested_table_type();

-- 
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 Tue Jan 22 2008 - 06:06:12 CST

Original text of this message