X-Received: by 10.69.20.107 with SMTP id hb11mr9993963pbd.2.1384189757131; Mon, 11 Nov 2013 09:09:17 -0800 (PST) X-Received: by 10.50.83.6 with SMTP id m6mr256838igy.1.1384189757048; Mon, 11 Nov 2013 09:09:17 -0800 (PST) Path: news.cambrium.nl!textnews.cambrium.nl!feeder1.cambriumusenet.nl!feed.tweaknews.nl!209.85.160.88.MISMATCH!z6no6617765pbz.1!news-out.google.com!9ni23264qaf.0!nntp.google.com!o2no29868392qas.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail Newsgroups: comp.databases.oracle.server Date: Mon, 11 Nov 2013 09:09:16 -0800 (PST) In-Reply-To: Complaints-To: groups-abuse@google.com Injection-Info: glegroupsg2000goo.googlegroups.com; posting-host=64.58.150.28; posting-account=tpQovAkAAABNoH5bwsZAiff2L0zxGwdv NNTP-Posting-Host: 64.58.150.28 References: User-Agent: G2/1.0 MIME-Version: 1.0 Message-ID: <8c029c7e-fd18-4a4e-9711-e98b39383e14@googlegroups.com> Subject: Re: Temp tablespace full From: joel garry Injection-Date: Mon, 11 Nov 2013 17:09:17 +0000 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Xref: news.cambrium.nl On Sunday, November 10, 2013 3:04:45 PM UTC-8, Trevor A wrote: > am getting the error Temp table-space full Another thing to look at is PGA memory usage details for multipass executio= ns. How exactly you would do that depends on things like your version, edi= tion, and licensing. The general idea is allow more sort area in memory, s= o you don't have to use so much temp. But there could be other things goin= g on that you are not telling us about. jg --=20 @home.com is bogus. http://readwrite.com/2013/11/08/in-the-age-of-twitter-do-we-need-oracle