Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: PL/SQL insert on 230K rows causes TEMP tablespace to grow to over 10GB

Re: PL/SQL insert on 230K rows causes TEMP tablespace to grow to over 10GB

From: <paul_swensen_at_splwg.com>
Date: 10 May 2006 18:02:57 -0700
Message-ID: <1147309377.887053.60980@y43g2000cwc.googlegroups.com>


Thanks VERY much. The first thing I checked was the statistics and that was the problem. The statistics are now current and the PL/SQL ran through fine with virtually no increase in TEMP size. Great stuff. Received on Wed May 10 2006 - 20:02:57 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US